SUMMARY:

• Above 10 years of professional experience in Providing end to end Data Solutions, BI solutions with client requirement Analysis, Physical and Logical design, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using AWS Redshift, SQL Server 2012/2014, SSIS,SSRS, SSAS, TABLEAU, Redshift, AWS, Power BI, Python .
• Used Python for Data Analysis / Data Transformations.
• Efficiently used AWS Redshift for new business Applications.
• Efficient in conducting Daily Stand ups, Project Review meeting, implementing SCRUM as Certified SCRUM MASTER/PMP .
• Effectively Involved in Project Planning, Execution and Closing of Projects as Part of Project Management.
• Experience in creating Dynamic SSIS packages with Exceptional Handling, Logging in SSIS.
• Performed Data Cleaning, Incremental Load, and Database Transfers using SSIS.
• Efficient in SQL SERVER Migration Projects.
• Experience in Import/Export of data from teh Heterogeneous Database such as Oracle and MS Access database, flat files to SQL server 2012/2014.
• Efficient in designing Tableau workbooks and worksheets to make effective Dashboard/Reports by Report users by themselves.
• Involved in Development of Reports in Pentaho.
• Master in designing and developing Enterprise Financial reports, Operational Reports using SQL Server Reporting Services (SSRS), Excel PIVOT, Tableau, Pentaho based on client requirement.
• Expert in developing Cubes and Dimensional Modeling in SSAS.
• Expert in Designing and developing Star Schema and Snowflake Schema with efficient Facts and Dimensions in SSAS.
• Involved in Normalization Technique for optimum Performance in Relational Databases.
• An enthusiastic and goal - oriented team player possessing excellent communication, interpersonal skills with good work ethics.

TECHNICAL SKILLS

Technologies: SQL Server 2000/2005/2008/2012, Analytics, .Net(C# and VB) 2.0\3.0

Languages: C, C++, SQL, T-SQL, PL SQL, C#, VB 6,VB .Net, Power Script.

Operating Systems: Windows server 2003/2012

Databases: SQL Server 2012/2008/2005/2000, MS-Access 97 & 2000, Oracle 9i, 10g, Excel.

Tools: SQL Server Management Studio, Visual Studio, SQL Server Business Intelligence Development Studio (SSIS, SSAS, SSRS), Tableau, Quikview, Pentaho.

Scripting: HTML, DHTML, C #, VB, Power Script, and VB, SQL.

Project Management: AGILE, AGILE SCRUM, WATERFALL.

PROFESSIONAL EXPERIENCE

Confidential, MA

Lead Data Engineer / Sr Data Analyst

Responsibilities:

• As a Data Management Professional at Enterprise Level worked with wide variety of tools like SSIS, DTS, SSRS, SSAS, Tableau, AWS Redshift, and Python.
• Used Python to do Data Analysis / Data Transformations.
• Involved in Data governance and Data Security across Enterprise level.
• Worked with AWS Redshift pushing data to cloud and making data available enterprise wide.
• Worked on End to End Data Warehouse solution for Complex Claim Integration Project.
• Worked on Design, Development and Deployment of new Life Insurance product Reporting Solution.
• Managed and involved in Burn down charts, Project Schedule Management, Resource Management a part of Project Management.
• Efficiently used SSIS for ETL in various stages of Data Warehousing.
• Efficiently handled important Enterprise Financial Reporting and Reconciled every from Top Source to End Reporting Destination.
• Responsible for Developing, Monitoring and Deploying SSIS packages in across 15 reporting Databases.
• Implemented Batch Logging, Error Logging for teh SSIS packages.
• Designed and Developed data models in Power BI for enterprise solutions.
• Designed, Developed and deployed efficient Facts, Dimensions and SSAS Cubes used across Enterprise from Executives to Daily Operations.
• Designed and Developed Table Work Sheets and Dash Boards in Tableau.
• Efficiently trained Report Users to use Tableau to create their Dashboards from pre-defined Work Sheets.
• As a Scrum Master conducted Daily Stand-ups, review meetings and removed road blocks from project.
• Developed different types of Tabular Reports, Matrix Reports, and Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Developed Cubes and done Dimensional Modeling in SSAS.
• Efficiently implemented OLAP/MOLAP with teh effective MDX scripting.
• Efficiently designed KPI’s, Partitioning in teh Cube development in teh OLAP.
• Developed multiple reports from SSAS.
• Involved in Development of Reports in Pentaho.
• Developed Complex Queries in T-SQL, Stored Procedures, and Views with best Execution plan.
• Implemented Data Modeling using Erwin Data Modeling Tool.

Confidential, MA

BI ENGINEER AND SCRUM MASTER

Responsibilities:

• OLAP Expertise with SQL Server business intelligence, including SSIS, SSRS, SSAS 2008/2012.
• Developed End to End SSIS framework to import data daily from OLTP Applications to data warehouse.
• Developed, deployed and Managed SSIS Packages including upgrading DTS to SSIS with efficient scheduling, Error Handling and Error Handling.
• Conducted Daily Stand-ups, review meetings and removed road blocks from project as a Scrum Master conducted Daily Stand-ups, review meetings and removed road blocks from project.
• Involved in Burn down charts review, Project Schedule, Resource Management as a part of Project Management.
• Troubleshoot ETL system issues, monitored scheduled jobs and set up maintenance plans with SSIS for proactively monitoring teh performance of SQL Server database.
• Developed Parameterized Reports using SQL Server Reporting Services (SSRS) based on requirement.
• Developed different types of Tabular Reports, Matrix Reports, and Drill-Down, Cross Tab Reports, Ad hoc reports, Parameterized reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Managing End to End Reporting Solutions designing, developing, deploying Reports.
• Used C# and VB in SSRS to increase teh Functionality.
• Design and Development of SSRS Analytic Reports from SSAS Cube using MDX Scripts.
• Development of Facts and Dimensions in teh SSAS Cubes.
• Efficiently managing teh SSAS Cubes with efficient Aggregations, Actions, Attribute Relationships and KPI’s.
• Designing and developing Star and Snow flake schemas in SSAS Cubes.
• Managing Data Modeling and Multidimensional modeling using Model Right.
• Maintaining teh Deployments of reports and ETL by Octopus Deployment tool.
• Efficiently Used Team Foundation Server (TFS) for teh Code Source Control.
• Experienced with Microsoft relational products SQL Server and Data Transformation Services.
• Developed Complex Queries in T-SQL, Stored Procedures, and Views with best Execution plan.
• Created User Defined Functions, Triggers, Indexes.
• Efficiently conducted Performance Tuning by using SQL Profiler, Data Engine Tuning Advisor and Stored Procedure.
• Implemented some modifications in teh database interface systems according to Business requirement.

Confidential, MA

SQL SERVER BI Developer

Responsibilities:

• Used teh SSIS to migrate Databases such as Oracle and Access database, flat file, SQL Server 2000 to SQL server 2005.
• Efficiently Migrated packages from DTS to SSIS.
• Responsible for Developing, Monitoring and Deploying SSIS packages.
• Implemented Batch Logging, Error Logging for teh SSIS packages.
• Parameterized Reports and Report Models using SQL Server Reporting Services (SSRS) based on client requirement.
• Developed different types of Tabular Reports, Matrix Reports, and Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Managed and Supported Complex reports like Drill Through, Parameterized using SSRS 2005.
• Designed complex reports like Cascaded Reports.
• Used C# and VB in SSRS to increase teh Functionality.
• Designed Web Forms using ASP.Net(C#Programming).
• Developed Cubes and done Dimensional Modeling in SSAS.
• Efficiently implemented OLAP/MOLAP with teh effective MDX scripting.
• Efficiently designed KPI’s, Partitioning in teh Cube development in teh OLAP.
• Developed multiple reports from SSAS.
• Developed cubes using SSAS with effective Dimensions and Facts.
• Managed Web Services using XML.
• Created Crystal Reports using Visual Studio 2005.
• Effectively designed teh star schema and Snow Flake schema according to teh Business requirements.
• Developed Complex Queries in T-SQL, Stored Procedures, and Views with best Execution plan.
• Implemented Data Modeling using Erwin Data Modeling Tool.
• Implemented some modifications in teh database interface systems according to Business requirement.
• Effectively modified Web Forms in teh .Net using C# coding.

Environment: MS SQL Server 2000/2005, SSIS, SSRS,SSAS,T-SQL, XML, Visual Studio 2005, MS Office, SQL Profiler, Windows 2000/2003,PB 7/11.5,Oracle 9i/10g,.Net 2.0,Microsoft Sharepoint, CRM, Erwin, Windows PowerShell.

Confidential, Pennsylvania

SQL SERVER BI Developer

Responsibilities:

• Processed data from FTP server using SSIS packages.
• Created Dynamic SSIS Packages which supports Batch Logging, Error Logging.
• Strong Skills in OLAP CUBE design and Development.
• Identified and defined Fact and Dimensional relationships in SSAS.
• Effectively developed OLAP/MOLAP.
• Efficiently made modifications in teh MDX scripting.
• Efficiently designed KPI’s, Partitioning in teh Cube development.
• Developed multiple reports from SSAS.
• Created parameterized, drill down and aggregation type of reports in SSRS 2005.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Implemented ETL process effectively.
• Gauged teh effectiveness and efficiency of existing reporting systems. Developed and implemented strategies for improving and further leveraging these reports in order to transfer/convert existing Reports to SQL Server Reporting Service (SSRS).
• Implemented more Functionality using VB.
• Logical and Physical design of database for projects on basis of user requirements.
• Created Tables, Functions, views and triggers using T-SQL.
• Analyze teh business situation, report, designed database and tables.
• Written T-SQL queries, created Complex Stored Procedures, Functions, Views, Cluster, Non-cluster Index and cursors to generate workflow.
• Experience in implementing Exception Handling.
• Migrated data using DTS from excel sheets, notepad etc to SQL Server Database.
• Design and implementation of stored procedures and Triggers for automating tasks.
• Worked on Production, Development, Documentation and Application Support.
• Worked on Performance Tuning and Optimization using T-SQL, Execution Plan, Index Tuning wizard, stored procedures debugger and Tables.
• Implemented some modifications in ASP.Net and also involved in ADO.Net Applications.
• Implemented business logic using Code behind files in C#.
• Efficiently made Power Builder Applications compatible with teh current latest Database versions.
• Effectively implemented Power Script and DATA WINDOWS modifications in teh PowerBuilder Applications

Environment: SQL Server 2005, SQL Server Integration services (SSIS), DTS, SSRS (SQL Server Reporting Services), SQL Server Analysis services (SSAS), Window XP, XML, Visual Studio 2005,PB 7/11.5,.Net 2.0.

Confidential

Data Analyst

Responsibilities:

• Assisting Professors and Departing in conducting exams, files management
• Worked as Data Analyst in Department providing info in Student Application process.
• Efficiently used MS Excel with Pivot Tables and Charts to Analyze teh Students Application Data.
• Efficiently documented Department procedures and practices.
• Provided Weekly, Monthly reports to Department head on Applications, Assignments and Scholarships.
• Assisted all Bachelor students in following Depart policies and practices.
• Efficiently maintained Professors and Department Schedule reports.

Environment: MS Excel, MS ACCESS, MS WORD.