Post Job Free

Resume

Sign in

Sql Server Data

Location:
India
Posted:
December 06, 2016

Contact this candidate

Resume:

Sindu

acxsb9@r.postjobfree.com

508-***-****

Professional Summary:

* ***** ** ************ ********** as a Business Intelligence Developer & ETL Developer in various business domains like Finance, Mortgage, and Communication & Healthcare.

Extensive experience in analyzing in huge data sets and data mining to identify patterns, trends etc.

Excellent experience and knowledge in modeling concepts like Conceptual Data Modeling (CDM), Logical Data Modeling (LDM), Physical Data Modeling (PDM), Star Schema, Snowflake Schema, Fact & Dimension tables, OLTP and OLAP.

Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.

Well versed in Normalization/de-normalization techniques for optimum performance in relational and dimensional database environments.

Hands-on experience with several BI tools, Reporting tools and Analytic tools like OBIEE, SSRS, Business Objects, Cognos, Tableau, Hyperion, Micro strategy.

Experience in Design, Development and Implementation of the enterprise-wide architecture for structured and unstructured data providing architecture and consulting services to Business Intelligence initiatives and data driven business applications.

Deep understating of Metadata management, Master data Management, Data Quality, Data Security, Data Governance & Data Stewardship.

Extensive experience in writing complex SQL Queries in T-SQL, SQL Server, Oracle, PL/SQL, MS Access and was involved in production support.

Good Experience in analysis and resolution of bottlenecks for performance tuning and optimizing SQL. Used Query Analyzer, Execution Plan to optimize SQL Queries.

Worked with ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data.

Knowledge in the ETL of data into a data ware house/date mart with Informatica and Data Stage.

Extensive experience in designing and deploying data visualizations using Tableau.

Excellent problem solving, troubleshooting and decision making skills.

Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files. Developing reports on SSRS on SQL Server.

Sound Experience and understanding of SSAS, OLAP cube and Architecture.

Client: Anthem, Virginia Beach, VA July 2016 – Present

Role: BI & ETL Developer

Anthem Inc. is a largest American health insurance company that delivers better health care to the members. As a developer my job is to develop stored procedures, SQL queries and apply ETL transformations required to generate the reports.

Responsibilities:

Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.

Developed and Extended OLAP Cubes, Dimensions and data source view using SSAS.

Created Dimensions with the cube wizard and also individually and Deployed Cubes to the production server.

Generated SSRS reports which included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drilldowns, drill through, sub-

Reports, navigation reports.

Created different Parameterized Reports like standard parameter reports, cascading parameter

Reports which consist of report Criteria in various reports to make minimize the report execution

Time and to limit the no of records required.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up, Merge Join as required using SQL Server Integration Services (SSIS).

Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to flat files.

Schedule SSIS jobs using Tidal Job Scheduler.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations like aggregator, expression, joiner, router, lookup, sorter, filter, union, update strategy, sequence generator using Informatica.

Created and scheduled Sessions and Workflows through the Informatica Workflow Manager.

Developed a Batch file to archive the bad files. All the batch files that are developed reside on the

Machine where Informatica server was installed.

Created stored procedures, views, triggers, user defined functions to incorporate the flow of business.

Reviewed Business Requirement documents (BRD), Software Requirement specification (SRS) and involved in preparing a Test Plan.

Create Test Plans, Test Cases and logs defects.

Conducted SQL, Oracle, and Teradata database testing by developing SQL Queries.

Automated Reconciliation at several levels on day to day basis.

Extensively involved in for end-to-end testing, Data Validations and Reconciliation of the Data Loads for the Mart.

Created schema and stored procedure to execute all the test scripts available in the table to check the number of scripts passed or failed.

Environment: SQL Server 2012, T-SQL, Oracle, MS Visual Studio, Business Intelligence Studio (SSRS), (SSAS), (SSIS), Informatica, MS Excel, Tidal Job Scheduler.

Client: Vizient Inc., Irving, TX Jan 2016 – June 2016

Role: BI Developer

Vizient Inc. is the nation’s largest member-owned health care services company. Backed by network-powered insights in the critical areas of clinical, operational and supply chain performance, Vizient empowers members to deliver exceptional, cost-effective care at every turn.

Responsibilities:

Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.

Identified trends and performance levels for metrics based on established benchmarks and created benchmarks using standard approaches.

Provided summarized findings and recommendations based on analysis in order to drive member improvement.

Provided analytical support & collaborated across the enterprise to evaluate healthcare data within client's full suite of data products.

Served as the point of contact for projects with minimal ambiguity around the customer's objective for analytic request including creating analytic data sets and coordinating ad hoc analyses to address member inquires & resolve anomalies.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up and Merge Join as required using SSIS.

Developed SSIS packages for File Transfer from one location to the other using FTP task.

Expertise in creating and managing Event Handlers, Package Configurations, Logging, Checkpoints and User Defined Variables for SSIS Packages.

Used ETL to implement the Slowly Changing Transformation to maintain Historical Data in Data warehouse.

Deployed complex packages from development to production environment using proper package configuration.

Scheduled the SSIS packages to keep extracting the data from OLTP at specific time intervals.

Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.

Created tabular, matrix, chart, drill down reports, parametric, cascaded reports and dashboards and score cards reports (SSRS) according to business requirement.

Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal and default like queried and non-queried.

Created Linked reports, Ad-hoc reports based on the requirement. Linked reports are created in the Report Server to reduce the repetition in the reports.

Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.

Working knowledge in creating Stored Procedures, Triggers, User-Defined Functions, Views, Indexes, User Profiles, Analytical Functions using T-SQL, SQL Server, PL/SQL.

Developed queries via joining various tables to validate the data coming with different data discrepancies using existing fields and quantifying results with calculations.

Performed performance tuning and optimization of queries and stored procedures for reports that took longer execution time using MS SQL Profiler which were sent to clients and managers.

Experience in working with Normalization/De-normalization, data design methodology and building Referential Integrity for the relational Database Model implementing as per business requirement.

Flexible and project oriented team player with excellent communication and leadership skills to develop creative solution for challenging client needs.

Environment: SQL Server 2014, Oracle, PL/SQL, MS Visual Studio 2012, Business Intelligence Studio (SSRS), SSIS, T-SQL, MS Excel.

Client: Anthem, Virginia Beach, VA Jan 2015 – Dec 2015

Role: BI & ETL Developer

Anthem Inc. is a largest American health insurance company that delivers better health care to the members. As a developer my job is to develop stored procedures, SQL queries and apply ETL transformations required to generate the reports.

Responsibilities:

Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.

Involved in reviewing business requirements and analyzing the data from various data sources for design, development, testing, and production rollover of reporting and analysis projects.

Created ETL packages with different data sources and then loaded the data into destination tables by performing different kinds of transformations like sorter, union, sequence etc. using Informatica.

Created and scheduled Sessions and Workflows through the Informatica Workflow Manager.

Developed a Batch file to archive the bad files. All the batch files that are developed reside on the machine where Informatica server was installed.

Participated in Technical and Code review meetings as the mappings are developed and tested.

Build common exception handling process to enable verification and validation capabilities and provide necessary audit.

Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.

Worked on complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and QA).

Worked on Reports (SSRS) with respective to various markets.

Successfully created Snapshots Report, Report Subscription, Data Driven Subscription and Report caching using Report Manager.

Generated SSRS reports which included various reporting features such as groups, drilldowns, drill through, sub-reports, navigation reports.

Created different Parameterized Reports like standard parameter reports, cascading parameter reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.

Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal and default like queried and non-queried.

Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.

Created Stored Procedures to validate the data coming with different data discrepancies using data conversions.

Created sub reports, bar chart, matrix reports, Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports for newly created Markets.

Involved in whole Agile process and Subversion and documented all the technical modifications.

Worked on production support and testing environment to ensure it’s according to the business rules, developed reports and involved in testing and deployment.

Created complex Stored Procedures, User Defined Functions, Triggers, Cursors, Tables and other SQL Joins and Statements by using T-SQL, SQL Server, Oracle, MS Access and PL/SQL.

Used SQL profiler and Execution Plan to view index performance and thereby eliminate table scan.

Involved in regression testing, and optimization of the query.

Test reports to ensure accuracy, remediate defects and developed rollout plan with business partners.

Environment: SQL Server 2008 R2/ 2012, Oracle, MS Access, MS Visual Studio, Business Intelligence Studio (SSRS), SSIS, Informatica, T-SQL, MS Excel.

Client: HealthCare Service Corporation, Richardson, TX Nov 2013 – Dec 2014

Role: BI Data Analyst

Health Care Service Corporation (HCSC) is the largest customer-owned health insurer in the United States and fourth largest overall, that holds the Licensee of the Blue Cross and Blue Shield Association in Illinois, Montana, New Mexico, Oklahoma and Texas.

Responsibilities:

Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.

Involved in reviewing business requirements and analyzing the data from various data sources for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications using Oracle, MS Access, SQL Server, T-SQL, PL/SQL.

Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

Developed complex mappings in Informatica to load the data from source tables using different transformations like Source Qualifier, look up, Expression, Update Strategy, Joiner and Router.

Designed and developed Informatica mappings for data loads and data cleansing.

Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert)

Worked on Error Handling and Logging in SSIS packages.

Created configuration table to set the properties of the objects of SSIS packages at runtime.

Implemented best practices for performance tuning of SSIS packages

Involved in error handling of SSIS packages by evaluating error logs

Successfully extracted transformed and load data into data warehouse.

Interacted with business users and team leads in correlating business specification, Identifying data sources and Development strategies.

Created dashboards according to user specifications and prepared stories to provide an understandable visualization. Involved in new KPI generation for Scorecards.

Created and published Tableau reports utilizing complex calculated fields, table calculations, filters and parameters.

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.

Making projections using forecasting models using table calculations and predicted the data for all transactions using trend lines.

Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, MS Access, SQL Server, T-SQL, PL/SQL and MS Excel.

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Reviewed basic T-SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Performed Performance Tuning and production support to resolve the bottlenecks.

Reconciled the report data with the source systems and reviewed it to find any data anomalies.

Test reports to ensure accuracy, remediate defects and developed rollout plan with business partners.

Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: Tableau Desktop, Tableau Server, MS Office Suite, PL/SQL, MS Access, SQL Server, T-SQL, DB2, Cognos, MS Excel and Informatica, SSIS.

Client: T-Mobile USA, Inc., Bellevue, WA Sep 2011 - Oct 2013

Role: BI Developer

T-Mobile USA, Inc. is an American mobile-network operator that provides wireless voice, messaging and data services in the United States, Puerto Rico and U.S Virgin Islands. It is the fourth-largest wireless carrier in the U.S. market. In addition to its cellular mobile network, the company operates a nationwide Wi-Fi Internet access network.

Responsibilities:

Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.

Worked on designing the OLAP systems for data mart applications using SQL Server Analysis.

Created SSIS Packages using Pivot transformation, Data conversion etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file and CSV files to data warehouse.

Designed Data flows, Workflows and jobs to load data from source to target.

Worked on daily batch loads like Full & Incremental into Staging and ODS areas, troubleshooting process, issues and errors using SSIS.

Worked on Error Handling and Logging in SSIS packages.

Enhancing and deploying the SSIS packages from development server to production server.

Identified fact, dimension tables and designed Data-Mart using Star Schema in SSAS. Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SSAS.

Created and Designed Data Source and Data Source Views and also configured OLAP Cubes (Star and Snow Flake Schema) using SSAS.

Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies in Dimensional Modeling.

Developed Aggregations, partitions and calculated members for cube as per business requirements.

Defined appropriate measure groups and KPIs and deployed cubes.

Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.

Created reports from OLAP, sub reports, bar chart, matrix reports, Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.

Successfully created Snapshots Report, Report Subscription, Data Driven Subscription and Report caching using Report Manager.

Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.

Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL, SQL Server, Oracle, PL/SQL and MS Access.

Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.

Performance Tuning and Production Support of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.

Environment: MS SQL Server, PL/SQL, MS Access, T-SQL, SSRS, SSAS, SSIS, ODBC, Erwin, MS Visual Studio, Microsoft Excel, Business Objects, OLAP, OLTP, Access.

Client: Dish Network Corporation, Englewood CO Sep 2009 – Aug 2011

Role: BI & ETL Developer

The Dish Network is a leading satellite television company. The company provides satellite internet, audio programming, and interactive television services to commercial and residential customers in the United States.

Responsibilities:

Actively prioritized and managed requirements throughout SDLC with all key stakeholders.

Worked on daily batch loads like Full & Incremental into Staging and ODS areas, troubleshooting process, issues and errors using SSIS.

Worked on complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Developed SSIS packages using various transformations such as Conditional Split, Fuzzy Look Ups, Aggregations, and Multicasting.

Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.

Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Developed complex mappings in Informatica to load the data from source tables using different transformations.

Implemented Slowly Changing Dimensions Type 1, Type 2 and Type 3.

Wrote Test Cases for testing each of the interfaces which were used by the QA team.

Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Developed and Extended OLAP Cubes, Dimensions and data source view.

Created Dimensions with the cube wizard and also individually and Deployed Cubes to the production server.

Worked on production support and testing environment to ensure it’s according to the business rules, developed reports and involved in testing and deployment.

Created ad hoc reports, chart reports, tabular and matrix and parameterized reports using SSRS.

Used BIDS to create parameterized reports and created several Excel reports using cube data.

Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements.

Performed data analysis to identify/ validate the data for accuracy, quality and integrity. Wrote and ran various SQL queries against Teradata, Netezza, SQL Server, Oracle, PL/SQL, MS Access and T-SQL to critically evaluate test results and performed Performance Tuning/ Production Support to identify bottlenecks.

Involved heavily in testing the reports and dashboard results by writing extensive SQL queries to check against the business requirements.

Environment: Microsoft Office Suite, Oracle, SQL, SQL Server, PL/SQL, MS Access, SSRS, SSAS, SSIS, T-SQL, Teradata, Netezza, Quality centre, Hyperion, OBIEE, JIRA, Informatica.

Client: Fannie Mae, Reston VA May 2008 - Aug 2009

Role: BI & ETL Developer

Fannie Mae is the leading source of residential mortgage credit in the U.S. secondary market, thus helping to build a sustainable housing finance system.

Responsibilities:

Worked on Field analyzing like identifying the business logic for each field, Participated in team meetings and proposed ETL Strategy.

Involved in ETL processes like Informatica and SSIS to apply necessary transformations and remove the duplicate data and correct the data and finally load it into the destination.

Created ETL packages with different data sources and then loaded the data into destination tables by performing different kinds of transformations using Informatica.

Setup folders, groups, users, permissions and performed Repository administration using Repository Manager and responsible for Error Handling and bug fixing.

Wrote PL/SQL Procedures for data extractions, transformation and loading.

Created SSIS Packages to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Developed SSIS packages with error handling and deployed them on to the QA and production server.

Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies in Dimensional Modeling.

Generated SSRS reports which included various reporting features such as groups, drilldowns, drill through, sub-reports, navigation reports.

Created Linked reports, Ad-hoc reports based on the requirement. Linked reports are created in the Report Server to reduce the repetition in the reports.

Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.

Actively involved in Performance Tuning and Production Support to resolve the bottlenecks.

Ran various T-SQL, SQL Server, PL/SQL, MS Access and SQL queries to evaluate the test results.

Skilled at transforming customer requirements into high quality end products via cost effective Lean/Agile processes employing continuous process improvement initiatives across business units.

Environment: Oracle, PL/SQL, Teradata, Business Objects, Informatica, SSIS, SSAS, SSRS, T-SQL, SQL Server, Microsoft Office suite, SAS.

Technical Skills:

DWH / BI Tools:

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Visual Studio, Crystal Reports, Business Object, OBIEE, Cognos, Hyperion

Programming Languages:

Base SAS, HTML, XML

ETL Tools:

Microsoft DTS/SSIS, Data Stage, Informatica Power Center

Database Design Tools and Data Modeling:

MS Visio, ERWIN, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Databases:

Microsoft SQL Server, MySQL, Oracle, DB2, Teradata, MS Access, Netezza

Business Tools:

MS Project, MS Office Suite, Rational Suite, MS Excel

Visualization Tools:

Tableau Desktop, Tableau Server, Tableau Reader

Education:

Master of Science in Information Technology.



Contact this candidate