SUMMARY

• 14 years of Experience in SQL Server, Oracle, SQL, PL/SQL, ETL, SSIS, PDI, Reporting, SSRS, Power BI, Tableau, Data Modeling, Data warehouse, Data Architecting, Performance Tuning and Database Administration
• Experience in Logical and Physical Data Modeling for OLAP/Data Warehousing using ER/Studio Data Architect, ERwin Data Modeler and Toad Data Modeler
• Having 8+ years of experience in creating Databases, Tables, Stored Procedures, Functions, DDL/DML Triggers, Views, Indexes and Cursors using SQL Server 2000/2005/ 2008R2/2012/2014, PostgreSQL
• Having 8+ years of experience in developing BI Applications using MSBI(SSRS, SSIS, SSAS), Tableau and Power BI
• Experience on developing Reports and Dashboards using Power BI and Tableau
• Experience in Designing and Developing complex ETL solution for handling millions of transactional data
• Experience in Oracle PL/SQL, Functions, Indexes and Performance tuning
• Experience on developing complex ETL packages using SSIS and Pentaho Data Integration (PDI) by consuming wide range of data sources
• Experience on developing BI reports like Tabular, Matrix, Drill down, Charts using SSRS
• Exposure on Pentaho Schema Workbench and Meta Data Editor
• Exposure on Schema Design, Indexing, Replication and Sharding using MongoDB
• Good experience on Performance tuning of Procedures, Functions and Queries
• Experience on Data Cleansing and Data Validation
• Experience in Migrating database from SQL Server 2014 to SQL Server 2017
• Exposure on implementing Dynamic Data masking in SQL Server
• Exposure on implementing Polybase options in SQL Server
• Experience in developing applications using .Net, C#, VB.Net and VB
• Consistently attending client Meeting and surpassing all deliverables defined by the customer/contract
• Involved in Application Design, Database design, Coding, Unit Testing and Code Review
• As a Team Lead I was responsible, to ensure all requirements for document storage and audit ability are met. Supporting documentation kept for business and/or legal reasons will be properly and completely stored using VSS/TFS
• Extensively worked on SCRUM and Agile Methodologies
• Used version controls like TortoiseSVN, VSS/TFS, Git
• Knowledge of SDLC, Change Management System, Incident Mgt & Reporting and data migration
• Hands on experience on generation of various matrices and reporting required by management and the client at several timeframe. Preparation of the SOW (Statement of Work) related metrics for project billing purpose
• Consistent, self - reliant and adaptable with the ability to learn the process quickly
• Excellent interpersonal skills, ability to work well with others
• Excellent Analytical and Problem-solving skills and motivational qualities along with zeal to work in team
• Worked extensively in Onsite - Offshore model
• Active participation in learning and dissemination of knowledge

TECHNICAL SKILLS

Databases : SQL Server 2000/2005/2008 R2/2012, PostgreSQL, Oracle 11g

NoSQL Databases: MongoDB, Cassandra

Data Modelling Tools: ER/Studio Data Architect, ERwin

Languages : VB.Net, C#, VB, Node.Js, Python

Web Technologies : ASP.Net, Java, JavaScript

Operating Systems : Windows-8/7/98/XP/NT/2000, DOS

Source Control Visual Source Safe, NG3, Perforce, TFS

Reporting Technologies : SSRS, Tableau, Power BI, Crystal Reports

ETL Tools : SSIS, Pentaho Data Integration

Cubes Design: SSAS, Pentaho Schema Workbench, SSAS Tabular model

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead/Technology Specialist

Environment: SQL Server 2017, SSIS, SSRS, Tableau, Power BI, TSQL, .Net, C#, ER Studio

Responsibilities:

• Analyzed requirements and generated mapping documents to map the requirements to the respective source systems
• Interacting with the Business users and Business Analysts in analyzing the requirements
• Designing Logical Data Model and Physical Data Model using ER Studio Data Architect
• Preparing ETL design document, data flow diagrams and architecture documents
• Preparing ETL mapping documents to represent information like data lineage, transformations, etc
• Generating DDL scripts based on the PDM and designing database
• Created Data Validation rules using SQL to validate the structure and integrity of the extracted data
• Designing and Implementing ETL packages using SSIS to support the data flow from source system to Management Dashboard Data warehouse
• Writing complex stored procedures, functions and queries using TSQL to support ETL packages
• Writing complex queries using TSQL to support Report/Dashboard design using SSRS
• Creating Reports and Dashboards using SSRS, Power BI, Tableau
• Writing complex TSQL code to support Front-End Dashboard application
• Performance tuning the ETL packages and procedures to do fast data loading
• Promoting the code to different environments by using different configuration files
• Preparing Unit test case documents based on the client requirements
• Execution of Unit test cases and documenting the test results
• Involved in peer code review and documenting the review comments
• Maintaining the code by using Source control
• Scheduling the Packages and monitoring daily schedules
• Maintenance and support of existing packages and reports

Confidential

Sr. Programmer Analyst/Sr. Developer

Environment: SQL Server 2012, SSRS, TSQL, .Net, C#, ER Studio

Responsibilities:

• Analyzing and understanding requirements documents
• Creating and Updating Low level design documents
• Creating and Updating Logical and Physical Models
• Converting the Physical Model to DDL scripts
• Writing complex procedures, Functions and Queries using TSQL
• Designing and Developing reports using SSRS
• Performance tuning of Stored Procedures, Queries
• Code review of the queries written by the team members