SQL/MSBI Developer

Rama Rao

Email:ac4pzn@r.postjobfree.com

Contact:248-***-****

PROFESSIONAL SUMMARY

Over 5+ of IT Experience in Software Analysis, Design and Development in Client/Server systems, Data warehousing and Business Intelligence applications.

Experience in requirement analysis, designing, coding, testing and evolution phases in a software development life cycle.

Experience in creating Indexes, Views, Triggers, Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.

Experience in writing Complex SQL Queries involving multiple joins.

Strong Knowledge of Relational Database Management System (RDBMS), OLAP&OLTP, Data Warehouse Concepts and experience with MS SQL Server in writing T-SQL, working on SSIS, SSRS, SSAS, Data Analysis, Data Cleansing and Data Migration.

Highly experienced working on SQL server integration services packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing ETL Purposes across different servers.

Excellent in High Level Design of ETL DTS Packages &SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Created SSIS packages to transfer data between OLTP and OLAP Databases.

Experience in creating and optimizing cubes on data warehouse using SQL Server Analysis Services (SSAS) of SQL Server 2008 using star and snowflake schemas for fact and dimension tables.

Involved in writing MDX queries and manipulating the multidimensional data in OLAP cubes.

Expertise in generating reports using SQL Server Reporting Services (SSRS) and scheduling and deploying reports on report manager.

Good knowledge in developing and designing reports through SSRS and Excel.

Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.

Designed and developed matrix and tabular reports with drilldown, drill through, parameterized reports, sub-reports using SQL Server Reporting Services (SSRS).

Enhancing the Reports visually by adding the visual elements like charts, graphs in SSRS reports.

Experience in creating Ad-hoc reports, data driven subscription reports by using report builder in SSRS 2008.

Good Knowledge of Normalization/De-Normalization and Data Modelling.

Proficient in Database Query performance optimization, debugging and performance tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.

Expert in working with trace files and execution logs.

Expert in database activities like database creation and maintenance, Performance Monitoring and Troubleshooting.

Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.

Education: Bachelor of technology in computer science from JNTU, Hyderabad, India.

TECHNICAL SKILL

Databases

: MS SQL Server (2008, 2008R2, 2014), ORACLE

DWH/BI Tools

: SSIS (2005, 2008, 2014), SSRS (2005, 2008, 2012), Crystal Reports, Business Intelligence Development Studio (BIDS), Visual Studio, Erwin Data Modeler.

Development skills

: T-SQL, PL/SQL, SSIS/SSRS/SSAS

Languages

: CICS, PL/SQL, T-SQL, OLAP, C#.NET, C++, ASP.Net. VB Scripting, HTML

Reporting Tools

: SQL Server Reporting Services, MS Excel,

Tools/Methodologies

: MS Visio, MS Project, SQL Profiler, MS Office

PROFESSIONAL EXPERIENCE:

Cotiviti Health Care (Blue Bell, PA) May17-Present

Role: Predictive Analytics Analyst (MS SQL)

Description: Cotiviti is a leading provider of payment accuracy and insight driven solutions that helps healthcare payers and retailers achieve their business objectives by unlocking value from the incongruities the company discovers in the complex interactions customers have with stakeholders.

Responsibilities:

Developed MS Access VBA code and SQL for the claiming compliance application.

Created Technical design specification documents based on the functional design documents and the physical data model.

Supported data extraction from legacy systems into flat files for loading into Puddle claims database.

Developed Stored Procedures in SQL for extracting and performing data transformations on the legacy data and load into the claims database.

Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.

Monitored and modified Performance using execution plans and Index tuning.

Responsible for Migrate Data from multiple sources like flat file and Excel to Single SQL Server table.

Used Stored Procedures, DTS packages, BCP for updating Servers.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Automated messaging services on server failures, for task completion and success.

Leveraged dynamic SQL for improving the performance, and efficiency.

Managed the migration of SQL Server 2012 databases to SQL Server 2014.

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

Developed highly efficient, complex batch T-SQL procedures and functions for serving ad hoc reports.

Created triggers on the tables enforcing data validation for better quality.

Used different type of transformations for data conversion, sorting and cleansing the data from different sources.

Used FTP and SFTP servers to transfer files to vendors.

Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.

Query Optimization and Performance tuning.

Performed backup/ restore, database objects such as tables, procedures, triggers, constraints, Indexes and views.

Environment: MS SQL Server 2014, VBScript, HTML, Version One, JIRA, Excel Application

T-Mobile (Atlanta, GA) Feb 16-March17

Role: MS SQL Server Developer/ Analyst (SSIS/SSRS)

Description: T-Mobile provides the identifying the product(s) most recently used by a subscriber (full device history for a subscriber). It verifies and validates the handset warranty status and also helps in the calculation and maintenance of warranty periods based on business rules and usage.

Responsibilities:

Installation and configuration of SQL Server 2012.

As a BI Developer analyzed the requirements and systematically designed the data mart for the online Services. Identified the dimensions, Fact tables and designed the data mart using star schema.

Worked with end users, business analysts and application developers to identify business needs and transforming business rules to database specifications.

Worked in creating complex Stored Procedures, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for the application.

Partitioned Tables and Indexes to load data from OLTP to an OLAP system to transfer the data quickly, efficiently and maintaining Integrity.

Developed ETL Processes using SQL Server 2012 Integration Services to migrate data from Oracle data source into a SQL Server 2012 database.

Created SSIS Packages by using different kind of transformations (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicast).

Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.

Deployed SSIS packages across development, test and production environments using project deployment model.

Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data. Multi-Dimensional Expression (MDX) to access them.

Generate KPI for customer satisfaction survey results and disease management.

Created various reports like financial, audit and monitoring reports using Parameterized, Drill down and Drill through reports, Sub Reports, and charts using SSRS.

Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus, making them user friendly.

Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.

Created, implemented and maintained a reporting suite of over 72 standard reports while also customizing many reports to meet individual client needs.

Deployed and scheduled Reports using SQL Server 2012 Reporting Services to generate all daily, weekly, monthly and quarterly Reports including current status.

Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.

Environment: MS SQL Server 2012\2008R2, SQL Server Reporting Services(SSRS)2012, Tableau SQL Server Integration Services(SSIS),Visual Studio 2010, TFS, Erwin, Agile Methodologies, Visio, Enterprise Manager, Crystal Reports 10, SQL Server Management Studio (SSMS),T-SQL,PL/SQL.

HP (Austin, Texas) Aug15-Jan16

Role: MS SQL Server Developer (SSIS/SSRS)

Description: This project’s goal is to provide services to consumers, small- and medium-sized businesses and large enterprises, develops and supports computers and related products and services including customers in the government, health and education sectors.

Responsibilities:

Worked with end users, business analysts and application developers to identify business needs and transforming business rules to database specifications.

Worked in creating complex Stored Procedures, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for the application.

Partitioned Tables and Indexes to load data from OLTP to an OLAP system to transfer the data quickly, efficiently and maintaining Integrity.

Developed ETL Processes using SQL Server 2012 Integration Services to migrate data from Oracle data source into a SQL Server 2012 database.

Created SSIS Packages by using different kind of transformations (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicast).

Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.

Deployed SSIS packages across development, test and production environments using project deployment model.

Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Connected Tableau server with share-point portal and setup auto refresh feature.

Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.

Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data. Multi-Dimensional Expression (MDX) to access them.

Implementing Facts and dimensions for providing views of large sets of data.

Created drill down, drill through, cascading parametric and sub reports from SSAS cubes that can be browsed on web.

Developed report specifications, created and modified reports using SSRS 2012.

Deployed and scheduled Reports using SQL Server 2012 Reporting Services to generate all daily, weekly, monthly and quarterly Reports including current status.

Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.

Environment: MS SQL Server 2012\2008R2, SQL Server Reporting Services(SSRS)2012, SQL Server Integration Services(SSIS), Visual Studio 2010, TFS,ErWin,Agile Methodologies, Visio, Enterprise Manager, Crystal Reports 10, SQL Server Management Studio (SSMS),T-SQL,PL/SQL, Tableau, tableau server.

Active Health Management, Chantilly, VA Jan 15 – July15

Role: SQL BI Developer

Description: Active Health Management basically provides health services in many aspects. Active Health Management is a leading provider of health management services, including disease management, clinical decision support and personal health records. My responsibility was implementation and maintenance of databases, Application Development, Generating reports and Analysing data.

Responsibilities:

Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).

Created partition table for very large database for good performance.

Involved in creation of Data Warehouse Cubes in SQL Server Analysis Service (SSAS).

Maintained system monitoring jobs and provide high availability support.

Participated Databases Architecture and data modeling design.

Performing DBA functions, installing, configuring and supporting database systems.

Reported all events and requirements through established reporting mechanisms in SSRS.

Expertise in developing web applications in Microsoft Visual Studio 2008 using ASP.Net, C#

Reviewed and developed data models and database designs with development teams

Wrote store procedures for some job automations.

Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.

Designed and developed OLAP using MS SQL Server Analysis Services (SSAS).

Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2005

Environment: MS SQL Server 2008, SSRS, SSIS, SSAS, ProClarity, C#, ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

AIG, Berkeley Hills, CA Apr14 – Dec 14

Role: SQL Server/SSIS/SSAS/SSRS Developer

Description: American International Group, Inc. (AIG) is a leading international insurance organization. AIG companies serve commercial, institutional and individual customers through one of the most extensive worldwide property-casualty networks of any insurer. In addition, AIG companies are leading providers of life insurance and retirement services around the world. In this project our team worked on fine tuning application logic for better performance.

Responsibilities:

Involved in Database maintenance plan and Implemented replication. Designed and implemented data access stored procedures and triggers for automating tasks.

Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.

Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.

Developed Stored procedures, Views, User defined functions in line with business requirements.

Developed SSIS packages to automate data retrieval data from Oracle, SQL Server, Excel and Flat Files using MS Business Intelligence (BI) tool.

Developed and Scheduled SSIS Packages for loading Facts and Dimensions.

Scheduled SSIS packages to automate incremental load of DataMart.

Developed, scheduled and generated variety of reports like List, Matrix, Chart and Sub Report and standard template by implementing SQL Server Reporting Services (SSRS).

Deployed and scheduled reports using SSRS to generate weekly and monthly reports.

Managed and coordinate with remote users for change request and optimization of application.

Scheduled SQL Server Agent jobs, alerts and designed and implemented user log in and security.

Prepare technical specifications and involve in end user training during hands off phase.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS),SQL Server Analysis Services, SQL Server Reporting Services (SSRS),Business Intelligence development Studio(BIDS),HTML, PL-SQL, Visual studio 2008, SVN.

Larsen & Toubro Ltd Jun 12 - Dec 13

Role: SQL Server Developer

Description: Larsen & Toubro Limited (L&T) is a technology-driven engineering and construction organization, and one of the largest companies in India's private sector. It has additional interests in manufacturing, services and Information Technology. L&T has an international presence, with a global spread of offices.

Responsibilities:

Involved in installation and configuration of SQL server 2000 on Servers.

Applied patches and service packs to keep the database at current patch level.

Learned to Implement database standards, naming convention for the database objects and maintain database security.

Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined data types and functions.

Implemented trigger and stored procedures and enforced business rules via checks and constraints.

Involved in data conversions and data loads from various databases and file structures.

Monitor failed and long running MS SQL Server jobs.

Environment: SQL Server 2005, DTS, T-SQL, Crystal reports7, ASP.Net.

Contact this candidate