SUMMARY:

• Over 9+ Years of Extensive Experience in Microsoft SQL Server 2012/2008 R2/2005 database development involving all stages of the SDLC (Software Development Life Cycle) with a demonstrated history of working in the government, financial, e - commerce and housing claims industry.
• Hands on experience on T-SQL, PL SQL, SSIS, SSAS, SSRS, MDX, DAX, PowerPivot, Tableau, Python, Power BI reports.
• Experience in writing Procedures, Views, Functions, Triggers, Subqueries, Correlated subqueries and dynamic SQL queries and other database objects using SQL and PL/SQL.
• Excellent in designing basic to complex SSIS Packages using various transformations such as fuzzy logic,lookup etc. to enable logging mechanism and schedule them.
• Experience in c onceptual, logical, physical data modeling using MS Visio and Erwin.
• Excellent in creating parameterized, drill down, drill through, linked and sub-reports using table, matrix, list, charts and gauge reports in SQL Server Reporting Services (SSRS).
• Extensive experience working on Data warehouse - creating data marts, cubes and working with MDX queries in SQL Server Analysis Services (SSAS) and Tableau dashboard reporting.
• Strong understanding and hands on experience with Snowflake schema, Star schema, SCDs, Data marts and Data warehouse designing.
• Experienced in Performance tuning techniques
• Created maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Experience in performing and supporting Unit testing (QA), System Integration testing (SIT), UAT and production support for issues raised by application users.
• Worked extensively in Agile and waterfall environments.
• An effective team player with exceptional planning and execution skills, outstanding communication skills coupled with exceptional presentation skills with the ability to perform tasks above expectations.

TECHNICAL SKILLS

Architecture/Development: Experience with high level enterprise architecture design and development.

Analysis/Design: Hands on experience in Database Modeling & Implementation.

Project Management: Experience in managing a team and training new members.

Quality Assurance: Experience with Unit, integrated, functional testing.

Technical Documentation: Expertise in creating high level technical analysis documents such as BRDs, User stories and technical documents.

TECHNICAL SKILLS:

Web Technologies: ASP.NET 4.0/3.5/2.0/1.1, ASP, CSS, ADO.NET, JQUERY, Web Services, HTML, XHTML, and Entity Framework.

Operating Systems: Windows 98/2000/2003, Windows XP/7/10, UNIX.

Languages: C#, SQL Server, T-SQL, SSIS, SSRS, SSAS.

Data Modelling: MS Visio and Erwin.

RDBMS: Microsoft SQL Server 2012/2008/2005, MS-Access.

Development Tools: Microsoft Visual Studio.NET, Excel.

Source Control: Team Foundation Server (TFS), Vault and JIRA.

Reporting Tools: Tableau, Power BI, SAS BI Dashboard and Report Builder.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Data Manager / Lead/Sr BI Developer

Responsibilities:

• Wrote complex Stored Procedures, Functions, CTE’s and DDL/DML statements.
• Created Individual SSIS Conversion Packages using various transformations such as Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, data flow task and execute Package Task.
• Scheduled daily refresh jobs from SQL Server agent, and provided support in case off ETL failure.
• Created data loads and Upgrade scripts for data migrations and validations.
• Designed the SSIS Package to update the Data mart from OLTP Database.
• Created multidimensional cubes from scratch for each business entity with dimensions and facts for Tableau dashboard reporting.
• Created, established relationships and processed Data Marts for each business entity.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.
• Fine-tuned queries, assigned proper Indexes for better performance.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.

Confidential, Wethersfield, CT

Senior SQL BI developer (SSIS, SSAS, SSRS)

Responsibilities:

• Wrote complex Stored Procedures, Functions, CTE’s and DDL/DML statements.
• Designed and deployed various SSRS reports such as drilldowns, drill through, parameterized and click through.
• Created normal and data-driven subscriptions on SSRS reports and scheduled them from job control.
• Managed and monitored SSRS metadata from Report Server database.
• Created multidimensional cubes from scratch for each business entity with dimensions and facts for Tableau dashboard reporting.
• Created, established relationships and processed DataMarts for each business entity.
• Wrote SSAS MDX Mathematical calculations and assigned KPIs within the cube.
• Created master ETL conversion packages which included various specific packages within, enabled logging mechanism and scheduled them to execute.
• Created and Scheduled ETL packages to shred XML data.
• Created Individual SSIS Conversion Packages using various transformations such as Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, data flow task and execute Package Task.
• Actively involved with the data migration process with the new data warehouse built.
• Performed optimization & tuned complex Transact SQL queries for better performance.
• Involved in data modelling sessions and provided suggestions on the data warehouse design.

Confidential, Hartford, CT

Senior SQL BI developer (SSIS, SSAS, SSRS)

Responsibilities:

• Actively involved in creation of stored procedures, Scalar functions, audit tables, triggers to clean and validate the data, so as to meet the company’s specifications.
• Created SSRS reports based on legacy crystal reports logic as a part of crystal to SSRS reports migration.
• Fine-tuned queries, assigned proper Indexes for better performance.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Applied schema change scripts to existing objects to synchronize with changing business rules by adding or enhancing relevant entities/tables, columns etc.
• Communicated with the client for collecting the requirement, document them, implementation the same.
• Scheduled daily refresh jobs from SQL Server agent, and provided support in case off ETL failure.
• Created data loads and Upgrade scripts for data migrations and validations.
• Provided support to downstream users regularly who are using SSRS reports.
• Implemented slowly changing dimensions to maintaining historical data in required dimension table.

Hershey’s, Hershey, PA

SQL developer / Data Warehouse Engineer

Project: Hershey POS (Point of sale) System.

Description: The project was mainly focused on point of sale data feeds designing through ETLs into data warehouse, work on ad-hoc reporting and designing marts.

Responsibilities:

• Created different Parameterized Reports (SSRS 2012) which consist of report Criteria in various reports to make minimize the report execution time.
• Created SSRS reports that call SQL Stored Procedures, initiate database updates and job calls based on actions taken by report user, enabling SSRS reports to function as an interface into a SQL database.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created dimensions and facts based on requirements.
• Created multidimensional cube with dimensions and facts for SAS dashboard reports.
• Involved in writing stored procedures, Views, User-defined Functions, CTEs for handling business logic and functionality of various modules.

Confidential, Albion, NY

SQL BI (SSRS, SSIS, SSAS) developer

Responsibilities:

• Created different report types like tables, matrix, charts, sub reports etc. Parameterized Reports (SSRS 2008) 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 consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created cubes with the pre-designed facts and dimensions.
• Using Erwin, created data models for the data warehouse and established relationships between fact and dimensions.
• Created data loads and Upgrade scripts for data migrations and validations.
• Involved in snapshot replication of the production database.
• Created complex stored procedures, Triggers, User-defined Functions, Views and Cursors for handling business logic and functionality of various modules.
• Provided documentation about database/data warehouse structures and updated functional specification and technical design documents.

Confidential, Irving, Texas

Software Engineer

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for handling business logic and functionality of various modules
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports and navigation reports.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.
• Fine-tuned queries, assigned proper Indexes for better performance.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• SSIS Packages were created to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed the SSIS Package to update the Data mart from OLTP Database.
• Responsible for the validation of the aggregate data from the ODS and the OLTP Database.
• Tested and implemented Database Mirroring solution for Production critical application.

Confidential

Junior Software developer

Responsibilities:

• Created Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T-SQL (DDL, DML) statements for application.
• Transformed data from various data sources using OLE DB connection by creating DTS packages.
• Defined stored procedures for module integrity and application.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Developed reports to generate daily, weekly, monthly, quarterly, yearly reports using crystal reports.
• Provided technical support to internal developers and external clients.