SUMMARY:

• Over8 years of extensive experience working with BI (SSRS, SSIS, and SSAS) and T - SQL using SQL Server 2000/2005/2008/2008 R 2/2012/2014.
• Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R 2/2012/2014.
• Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Performance Tuning in SQL Server - Using SQL Profiler, DTA (Database Tuning Advisor), HINTS, Effective use of DMV’S/DMF’s, Optimization for AD-HOC Workloads, Parameter Sniffing, DBCC commands, Partitions & Partitioning, Bulk Loading Data(BCP),Indexed Views & Schema Binding, STATS, Clustered/Non Clustered Indexes.
• Experience in maintenance jobs to perform Full, Differential and Transaction Log backups using Simple, Bulk-logged and Full Recovery Model experienced with Database Backup, Recovery solutions.
• Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access using SQL Server SSIS 2000/2005/2008 R2/2012
• Proficient in Extraction Transformation and Loading (ETL) process by pulling large volumes of data (VLDB) from various data sources using SSIS.
• Worked in Migrating of DTS Packages to SQL Server Integration Services (SSIS) from Lower Version (2000/2005) to Higher Version ( 2005/2008/2012 ) and troubleshoot migration issues.
• Experience in designed Data Conversions from wide variety of source system using SSIS.
• Experience working with different SSIS Configuration options and Deployment Methods for different environments use.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience working with Data Cleansing technique in ETL process.
• Hands on experience working with different types Dirty Data from different sources.
• Hands on experience loading Data warehouse for both Dimension tables and fact tables by initial load/ongoing load process using SCD, MERGE, CDC, Parent/Child SSIS packages.
• Excellent Hands on Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Experience as Report Writer for understanding each client business reporting requirement, designing, creating and maintain of simplex to complex reports.
• Experience in generating reports for OLTP and OLAP databases.
• Experience with scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
• Heavy experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Hands on experience working with Self Service MS BI end user tools such as Excel 2010 (Power pivot), Performance Point Service (PPS) and Power view.
• Developed the SSAS 2012 Multidimensional and Tabular model reports from Data warehouse using SSDT.
• Experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snow Flake schema) using SQL Server 2005/2008/2012 Analysis Services (SSAS).
• Excellent hands on experience in creating groups and measures, KPIs.
• TFS, SVN, ERWIN, Power Designer
• Application Architecture/HLD Documents, Requirement Document(BRD),Detailed Design Documents(FSD/LLD),Maintenance and Operations (M&O) Documents, System Interface Documents, Data Model Documents, Configuration Management Documents
• Sound Knowledge in front end applications like C# .NET, ASP.NET.

TECHNICAL SKILLS:

Databases: SQL Server 2012/2008R2, 2005 & 2000/7.0, MS-Access 2000, Oracle 11g/10/9i, DB2

Database Tools: SSMS, BIDS/Visual Studio, TOAD

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, SQL* Plus

Languages: C, C++, VB.NET, C#.NET, JAVA, PHP, UNIX, SQL, T-SQL, PL/SQL, MDX, DAX, RDBMSSQL Server 2000/2005/2008 R2/2012 T-SQL, Oracle 11g/10/9i Pl/SQL

IDE: Visual Studio 2003/2005/2008 R2/2012

OS: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP

Other Tools: Erwin/Power Designer (Data Modeling), Visio, Visual SourceSafe, MS Office suite, Quality Control(QC), Tidal Jobs.

Architecture: Relational DBMS, Client Server Architecture, OLAP, OLTP

IT Processes: Software Development Life Cycle (SDLC)

Methodologies: Agile, Waterfall, Scrum, SDLC

PROFESSIONAL EXPERIENCE:

Confidential, NY

MS BI Stack (SSIS| SSRS|SSAS)| T-SQL Developer

Responsibilities:

• With project planning, participating in client meetings for understanding functional and business prospective of the project.
• Responsible for design and creating the complex SSIS packages and demoing to the team.
• SSIS packages build with OLEDB data sources from Mainframe SAS files and loaded the data into target SQL Server database by performing different kinds of transformations like Lookup, derived Columns, conditional split.
• 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 using SQL Server Integration Services (SSIS).
• Worked on Tidal Job scheduler for scheduling batch files which contains the SSIS packages using DTExec command.
• For creating documentation on the entire Project that we developed and validate the information that we took from other team and also useful for giving demos to higher management.
• Created databases, tables, views, Joins, triggers, functions, union, Merge, indexes, constraints, stored procedures and SSIS packages based on business requirements.
• Deployed the SSIS Packages to DEV and QA Environments and then deploy into Production.
• Created SSRS reports for Payroll system with using Tabular, Matrix reports, Charts and graphs as per HR Management requirement.
• Involved building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
• For understanding the existing SSAS cubes.
• Involved and implemented facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2008/2012 that maintained data.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.

Environment: SQL Server Data Tool 2012, SQL Server 2014, 2012, 2008, SSIS 2012, 2008, SSRS 2012, 2008,, SSAS 2008,2012, Visual Studio 2010/2013.

Confidential, NY

MS BI Stack (SSIS| SSRS|SSAS)| T-SQL Developer

Responsibilities:

• In ETL packages - worked with Flat File data sources and loaded the data into target Sql Server db by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for understanding the complex SSIS packages and demoing to the team.
• Data migration (import & export) from Text to SQL Server and vice versa.
• .Responsible for creating documentation on all the applications so that our team can validate the information that we took from other team.
• With participating in client meetings for understanding functional and business prospective of the project.
• Created databases, tables, views, Joins, triggers, functions, union, Merge, indexes, constraints, stored procedures and SSIS packages based on business requirements.
• Deployed the SSIS Packages to DEV and QA Environments and then deploy into Production.orked on Tidal Job scheduler for scheduling batch files which contains the SSIS packages using DTExec command.
• Responsible for understanding the SSAS cubes.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Created Tabular, Matrix reports, Charts and graphs, Dashboards Reports as per customer requirements Using SSRS 2012.
• Dealt with SSRS Reports which we are getting from SSAS cubes.

Environment: SQL Server Data Tool 2012, SQL Server 2012, 2008, SSIS 2012, 2008, SSRS 2012, 2008,, SSAS 2008,2012,Tidal Jobs, Visual Studio 2010/2013.

Confidential, Overland Park, KS

SSRS| SSIS|SSAS-T-SQL - Developer

Responsibilities:

• Responsible for converting Teradata scripts into SQL Server scripts.
• Experience working with Relational Data Modeling using Power Designer.
• Involved in writing T-SQL Programming for implementing Complex Stored Procedures and User Defined Functions for different tasks.
• Created and debugged complex stored procedures, views and functions for better performance and flexibility.
• As Report Writer, Created reports by generating data models and also generated Ad hoc reports.
• Responsible for designing ETL solutions/ framework with SSIS.
• Responsible for the performance tuning of the ETL packages.
• Worked on various tasks and transformations likeExecute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookupwhile loading the data into Destination.
• Worked on Maestro job scheduler for scheduling teradata scripts and 2012 SSIS packages.
• With the supervisory role responsible for project planning and estimates, participating in client meetings for understanding functional and business prospective of the project.
• Created several tabular, matrix, sub reports,cascading,graphical, multiple groupings, Drilldown,Drill through reports, parameter driven, formulas, summarized and conditional formatting using SSRS.
• Dealt with SSRS Reports which we are getting from SSAS cubes.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Responsible for understanding the SSAS cubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Reports were developed on Excel 2010, Power Pivot for providing ad-hoc/Self Service reporting for the clients.

Environment: SQL Server 2005, 2008R2, 2012, SSIS 2008, SSRS 2008, SSAS 2008,Visual Studio 2010, MS Excel 2010, Power Designer.

Confidential, Boston, MA

SSIS| SSRS|T-SQL - Developer

Responsibilities:

• Converting already existing SSIS packages which are pointing to SQL Server to Oracle.
• Scheduled and maintained routine jobs, tasks, and alerts using SQL Server Agent.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like Oracle.
• Created/Modified multiple SSIS packages. SSIS packages were used to bring the application data from SQL Server to oracle and to text files as extracts/reports. Also used SSIS packages to store data on third party FTP sites.
• As Report Writer I Designed and implemented reports with different layouts using SSRS 2008R2 and also with mainframe systems.
• Query Optimization, Tuned some SP’s/Queries/views for excellent performance upgrades like one Job was taking 6.5 hours reduced it to 1.5 minutes.
• Responsible for creating/migrating undocumented crystal/SSRS reports.
• Created several Complex Reports (tabular, matrix, sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2008.
• Worked on Defect Fixing Using Quality Control (QC).

Environment: SQL Server 2008R2/2005/2000, SSIS 2008, SSRS (2008), Oracle, Visual Studio.

Confidential

SQL Server SSRS|SSIS|T-SQL Developer

Responsibilities:

• Created the ETL (SSIS) packages and scheduled them for SQL Agent Jobs.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Extensively worked in data integration in developing ETL mappings and scripts using SSIS
• Data migration (import & export - BCP) from Text to SQL Server and Vice versa.
• Implemented batch processing using Jobs and DTS.
• Involved in Designing, Developing and Testingof the ETL(Extract, Transformation and Load) strategyto populate thedatafrom various source systems feeds usingSSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for codingSSISprocesses to import data into the Data Warehouse fromExcelspreadsheets, Flat Filesand OLEDB Sources.
• Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Created Packages, Jobs and Sending Alerts using SQL Mail.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Created several CHARTS, sub reports, parameter driven and formulas using SSRS.

Environment: SQL Server 2000, 2005, 2008, SQL Profiler, Visio, Excel 2007,DTS, SSIS 2005,2008, SSRS 2008.