SUMMARY

• Around 8+ years of Experience as SQL Server Developer/Data Analyst/Data Modeling with emphasis on Data Mapping, Data Validation in Data Warehousing Environment with various domains like Health, Financial and Insurance.
• Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERWIN and Power Designer.
• 3+ years’ knowledge in Microsoft SQL Server, Visual Studio, Microsoft SSIS Microsoft Reporting Services and TFS.
• Extensive knowledge of data integration and processing including extraction, transformation, and loading (ETL).
• Experience in SQL Server, T - SQL, Stored Procedures, Triggers, UDF, BCP, DTS, SSIS, SSAS, SSRS packages, and Oracle 9i/10 g, PL/SQL.
• Develop complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL, SSIS or Informatica toolset (Powercenter, B2B with MFT)
• Experience in working on Dash boards using QlikView, Qlik Sense, SSIS, Power BI like web-based reports, scorecards and Tableau reporting tools.
• Experience in developing Entity-Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like ERWIN, ER/Studio and Power Designer.
• Experience in creating/deploying Data Transformation Services (DTS), Knowledge of Integration Services (SSIS) packages, Analysis Services (SSAS) and Reporting Services (SSRS).
• Experience in TSQL-DDL/DML/TCL/DCL, perform most of the SQL Server Management Studio functionality using T-SQL Script.
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS and in built GLOBAL VARIABLES for the instant analysis.
• Worked the backend by using Node js, PostgreSQL, SQL and MongoDB.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure for finding out long running queries.
• Experience in automating process by creating jobs and error reporting using Alerts,SQLMail Agent, FTP and SMTP.
• Experienced with Crystal Reports, Cognos and SSRS - Query, Reporting, Analysis and Enterprise Information Management.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using tools like SSIS import and export, SSIS packages, and DTS package.
• Familiarity with SSAS, Cognos, QlikView,GreenplumDatabase, Amazon Redshift, or Azure Data Warehouse.
• Excellent troubleshooting & optimization skills: interpreting ETL logs, performing data validation, dissecting SSIS code, experience with change data capture, using expressions, scoping of variables, commonly used transforms, Event Handlers and logging providers, ability to understand and optimize the surrogate key generation and inconsistent data type handling.
• Collaborated with the Data Stewards, Architecture, and Information Technology to prioritize and resolve: data sourcing, business rules, data aggregation, data distribution, and data consumption.
• Checking the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment.
• Performed data cleaning, data validation, and data analysis using Data Analysis expressions (DAX), Power Query and Power Pivot.
• Experience in Testing and maintaining data integrity across multiple databases (internal SAS, DB2, VSAM; external: Adobe, Excel, SAS parsing routines, COBOL).

TECHNICAL SKILLS

Data Modeling Tools: Erwin, MS Visio, ER/Studio, Sybase Power Designer

ETL Tools: SSIS, SSAS, Power Exchange, Data stage, DTS, TOAD

Database Tools: Oracle,9i/10g My SQL, SQL postgre, SQL *PLUS, SQL*Loader, Teradata SQL Assistant, SQL Server Management Studio, DB2, Win SQL, RDBMS Oracle

BI Tools: Crystal Reports, SSRS, Business Objects, Tableau, Power BI, Qlik

Languages: SQL, PL/SQL, ASP, Visual Basic, XML, JAVA, HTML, T- SQL, SQL Server VB SCRIPT and C++

Performance Tuning Tools: SQL Profiler, DTA (Data Tuning Advisor)

PROFESSIONAL EXPERIENCE

Confidential - Minneapolis, Minnesota

Sr. SQL Server Developer/Data Analyst

Responsibilities:

• Participated in JAD sessions, gathered information from Business Analysts, end users and other stakeholders to determine the requirements.
• Experience with total SDLC process (design, documentation, development, unit testing and deployment)
• Experience with using the different aspects ofSQLprogramming like Joins, CTEs for performing accurate and expedited data analysis.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and at theSQLSERVER LEVEL.
• Developed data mapping documents for integration into a central model and depicting data flow across systems.
• Worked withSQLServer Integration Services in extracting data from several source systems and transforming the data and loading it into ODS.
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like Erwin.
• Performed data analysis and data profiling using complexSQLon various sources systems including Oracle and Teradata.
• Developed stored procedures and complex packages extensively using PL/SQLand shell programs.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Build models to interpret data using statistical analysis and develop recommendations based on findings.
• Ability to create and modify new and existing Crystal Reports.
• Development of ETL processes to cleanse, transform, and load data into an OLTP structure including logging and a bad record handling.
• Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues.
• Experience in writing SQL queries, create end-user reports, and apply varying analytical techniques to solve specific business problems.
• Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.

Environment: Oracle, TOAD, DB Visualizer, ODBC, TOAD Data Modeler, Crystal Reports, ER Studio, JIRA, UML, WinSQL, MS SQL Server, MS SQL Integration Services, MS SQL Analysis Services, MS SQL Reporting Service, Erwin3.5, MS Excel, Windows, SharePoint Site.

Confidential - Chicago, IL

Data Modeler/BI Architect

Responsibilities:

• Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and Physical data Models.
• Developed dashboards using Qlik View, Qlik Sense, Tableau, Power BI.
• Identified the grain, key dimensions, facts and designed Star and Snowflake schema.
• Design Data Models that simplify reporting and support front-end BI reporting tools.
• Experience in creating Data Models in Qlik View and Qlik Sense, creating tables, charts, graphs, drill down operations and performed Scripting using Set Analysis.
• Extensive knowledge of writingSQLqueries, working with back end tools such asToadfor data validation and verification.
• Prepared High Level Logical Data Models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Accomplished key tasks in Postgre SQL Environment such as preparing a Unix environment for a PG installation, to create roles, users, and privileges, and to remove an installation.
• Development of methods and objects using TSQL, SQL XQuery, XML, Merge, Common Table Expressions, Pivot and Unpivot.
• Worked as a part of ICDW Migration Testing Project where the duties were to writing SQL queries and executive the queries to match with thedatain the target.
• Worked with Optimization technique to improve the performance of the Dashboard, Data Libraries and Reports.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for on-going maintenance and change management to existing reports and optimize report performance in SSRS.
• Provisions were made for ad hoc querying and reporting using Crystal Reports.

Environment: Power Designer, MS Office (MS Word, MS, Access, MS Excel, MS PowerPoint, MS Visio), .NET, Qlik, Tableau, Power BI, Teradata, Business Objects, Sybase, UML, SQL, SAS,ETLAbinitio, TSQL, Microsoft Visual Studio 2016, Query Analyzer, SQL Query Manager, Teradata SQL Assistant, Agility Workbench, XML files

Confidential - St. Louis, MO

Associate PL/SQL/ ETL Developer

Responsibilities:

• Involved in ETL Architecture, Developing Source to target data mapping (STDM) document defining transformation logic.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Worked on multiple data sources to bring in required data needed for different systems such as CORPSCAN and VTSCAN
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Document all the data after pulling the data from database such as CORPSCAN server, used different sites such asSharePoint and discovery sites into excel sheets.
• Development of automated job scheduling processes to allow both serial and parallel processing of SQL Server procedures.
• Experience in client-server application development using Oracle Toad,SQL* Plus,SQL*LOADER andPL/SQLdeveloper
• Created SSIS packages to load the data from Text File to staging server and then from staging server to Data warehouse
• Developed Procedures, Functions, Cursors, Triggers and Packages usingPL/SQLDeveloperto implement business logic
• Responsible for SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks.
• Developed methods and objects using TSQL, SQL XQuery, XML, Merge, Common Table Expressions, Pivot and Change Data Capture.
• Development and use of unit tests to test and validate SQL objects during and post development and deployment
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Optimized and tunedPL/SQLsubprograms to reduce the loading process.
• Involved in performance tuning (PL/SQL) usingSQLTrace, Explain Plan, TkProf and Indexing
• Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.

Environment: SQL Server Enterprise Edition, Oracle, PL/SQL, Visual Studio, SQL Trace, SQL Profiler, SSRS, SQL Reporting services Add-in, MS Access, Power Shell, XML, Shell Scripts, UNIX, MQ Migration Tools, Toad,SQL* Plus,SQL*LOADER

Confidential - Jersey City, NJ

ETL Developer

Responsibilities:

• Creating the UNIX shell scripts for processing files, validation and archival.
• Extracted data from Oracle, Excel and flat files into SAS Datasets.
• Designed SSIS Packages in SQL Server to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Worked on Power Centre client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformations Developer.
• Worked on XML transformations to send input to Permits as per specifications.
• Coordinate and track source code and document versioning with other developers using Git and TFS
• Design, develop, and maintain various user-friendly dashboards in Tableau server using various reproducible data sources, stored procedures, view, calculations, and parameters.
• Have created POCs to store data on PostGre sql, Cassandra CQL (creating Key spaces, Storing and retrieving data from tables, Filtering data based on multiple columns)
• Provide timely, accurate and reliable management reporting and analysis of data.
• Using XML stage to read the JSON file and loaded into the database.
• Using Execute Command activity to download the JSON file from API's using CURL command.
• Involved in Analyzing, designing, building &, testing of OLAP cubes withSSAS2005 and in adding calculations using MDX.
• Have done a POC on PostGre sql to replace SQL server for RAN data storageUsing SSIS. Loaded few TB of data into PostGre Sql.
• Expertise in using different tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event- Wait)
• Used Debugger and Breakpoints to view and edit transformations output and debug mappings.

Environment: SQL, PL/SQL, MS SQL Server, Source Analyzer, MDX, JSON, XML, CASSANDRA, PostGre sql, Git, TFS, Oracle, DB2, Shell Scripting, Mainframes, SAS Datasets.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with users, team lead and DBA’s and technical manager to fully understand the requirements of the system.
• Designed the data stage jobs for extract, transform, CDC, and load process.
• Integrate data from multiple data sets, analyzed and interpret complex data sets and make findings relevant and actionable for both internal and external stakeholders
• Extensive knowledge of data integration and processing including extraction, transformation, and loading (ETL).
• Analysed, designed, implemented and tested new tables in SQL Server and developed Stored Procedures.
• Worked HP Quality Center to resolve Data related defects.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spread sheets and vice versa.
• Created checks and constraints to maintain data integrity across the data in the database.
• Used SQL developer to Load / Extract data into and from Excel files.
• Created/Modified Tables, Views, Stored Procedures, Functions, Indexes and Triggers
• Improved existing Dashboards, ensuring efficient reload times and per formant front end calculations.
• Participated in numerous Data Modelling sessions with DBA and reviewed clustered and non-clustered indexing options.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Created ETL/SSIS packages to extract data from various sources like Excel, Flat files to SQL server systems using different SSIS.
• Experience in creating ad-hoc reports by using Excel and Report Builder in SSRS.

Environment: MS SQL Server, SQL server reporting Services, SQL integration Services, SQL Analysis Services, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, Flat Files, XML