SUMMARY

• Over 8 Years of experience in MS SQL Server 2012/2008R 2/2008/2005/2000 with Business Intelligence in MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS)
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Experience in Managing Security of SQL Server 2012/2008R2 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data, COSMOS) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Developing reports on SSRS on SQL Server (2000/2005/2008/2012 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Created Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets. Developed several SSRS reports including Drill Down, Drill through cascading parametric reports.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
• Great ability to create and manage various database objects like tables, views.
• Worked Extensively on ETL process using SSIS package.
• Experience in usingDataModelingTools like Erwin, MS access and Microsoft Visio.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in using T-SQL in SQL Server 2000/2005/2008 and 2012 platforms.
• Experience in Performance Tuning and Query Optimization.
• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Experience in creating packages to transfer data between ORACLE, MS ACCESS, COSMOS and Flat Files to SQL Server using DTS/SSIS.
• Expert in creating Parameterized Reports.
• Extensively worked on developing and debugging Informatica mappings, sessions and workflows.
• Validation of Informatica mappings for source compatibility due to version changes at the source.
• Hands on experience in Creating datamarts in Star Schema and Snow Flake Schemas.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS,SQL Server Data Tools, Tableau, Informatica.

Database: MS SQL Server 2012,2008 R2,2008, 2005, 2000, SQLCMD, Microsoft Office 2007/2003, MS-Access.

Language: C,C++,HTML,XML,TSQL,PL/SQL,MYSQL,DHTML,VB.NET,ASP.NET,.NET Frame Work, C#, JavaScript

Operating System: Windows XP/NT/ 2000/2003/2008 , DOS

Tools: Erwin Data Modeler, MS Visio, SAS/Access, Crystal Reports8.5,10,XI,R2,BusinessObjects,Microsoft office 2003/2007.

PROFESSIONAL EXPERIENCE

Confidential - Railegh, NC

MS SQL BI Developer (SSRS, SSAS, SSIS)

Responsibilities:

• Utilized documentation prepared by Business Analyst to complete projects.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Migrated data from different sources (text based files, Excel spreadsheets,Sybase,Oracle) to SQL Server databases using SQL Server Integration Services (SSIS).
• Created SSIS package to load data from Flat File (2GB -- 4GB) to Flat File and Flat File to SQL Server 2008R2 using transformations including Lookup, Derived Columns and Condition Split, .
• Deploy and Schedule SSIS packages using SQL server agent for incrimental load of datawarehouse.
• Creating and managing scheme objects such as tables, views, clusters, Indexes, Procedures, triggers and maintained Referential Integrity.
• Implemented automated jobs for Database Backup on a weekly and monthly basis.
• Implemented complex conceptual database design and database architect into SQL Server 2005/2008R2 using various constraints and triggers.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Using Visio 5.0 design different kind of Data Models for various kind of databases as per the requirement.
• Involved in DimensionalDataModelingand Cube partitioning in SSAS.
• Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts.
• Created ad-hoc reports using SQL server 2008 R2 Reporting Services (SSRS).
• Deployed 2008 R2 Reporting Services (SSRS) RDL files to Reports server.
• Develop multi dimensional cubes using SSAS to cater various business needs.

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2008(SSRS), SQL Server Integration Services 2008(SSIS), VSS, Microsoft Visual Studio, SSMS, ASP.NET, MS Excel, T-SQL.

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 likeOracle.
• 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.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• AsReport WriterI Designed and implemented reports with different layouts usingSSRS 2008R2and 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/migratingundocumentedcrystal/SSRS reports.
• Created several Complex Reports (tabular, matrix, sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) usingSSRS.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2008.
• Worked on Defect Fixing Using Quality Control (QC).
• Generating PowerShell scripting to avoid errors and also used for SSRS.
• Used PowerShell script for SQL Server Maintenance activities.
• Developed mappings, sessions and workflows in Informatica power center.
• Working with Tableau, Spotfire, Qilkview, Logi XML tools for reporting.
• Worked on the Reports module of the project as a developer on MS SQL Server 2012/2008R2 (using T-SQL, scripts, stored procedures and views).
• Strong T-SQL, MDX and DAX skills and experience deriving scalable reports from data management frameworks

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

Confidential - Houston, TX

SQL Server / BI Developer

Responsibilities:

• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2008R2/2008 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• Worked with development teams in the design of physical databases and in modification.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
• Responsible for developing SSIS packages/Informatica/BCP to load data from Netezza toSQLServer
• Involved in requirement analysis, ETL design and development for extracting data from the source systems like sales force, Mainframe, DB2, sybase, Oracle, flat files and loading intoNetezza.
• Created Rich dashboards usingTableauDashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Designed and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 Reports Services (SSRS).
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Developed SSIS process design architecting the flow of data from various sources to target.
• Built ETL SSIS packages both design and code to process data to target databases.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Help in leading team in creating SSIS templates for developing SSIS Packages.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance

Environment: Windows 2003/2008 Server, MS SQL Server 2008R2, BIDS, ASP .NET, XML, SSIS, SSRS, Tableau, Service Broker, C#, MS VSS.

Confidential

SQL Server BI Developer

Responsibilities:

• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Designed and implemented Disaster Recovery Procedures like Log Shipping and mirroring between production and DR servers.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• UsedSQLprocedures to load the data from other sources likemainframesto ORACLE database
• Built connections to/pulling data from AS400,mainframe/db2 and Oracle.
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Migrated legacy database and spreadsheets (Access/Excel) to SQL Server 2000 using Data Transformation Services (DTS) and T-SQL scripts.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select statement in certain queries.
• Experience in using Polybase to query both structured and unstructuredBigDatathrough T-SQL
• Created views to restrict access to data in a table for security.
• Developed computer information resources, providing for data security and control, strategic computing, and disaster recovery.
• Used ER-WinDatamodelingtool to design and implement Logical and Physical models of various Relational Databases.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL Server 2005 for further Data Analysis by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Build SSIS package to handle data from Oracle 10 g,Mainframesystem applications and external files
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases. and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.

Environment: SQL Server 2000/2005, SSMS, SSIS, SSRS, SSAS, HTML, CSS, Java Script, Team Foundation Server,IIS 7.0

Confidential

SQL Server Developer

Responsibilities:

• Maintain database dictionaries, monitor overall standards and procedures, and integrate enterprise systems through database design.Develop, review, and optimize queries for data retrieval and update.
• Developed shell scripts in PERL for the application server.
• Written and developed shell scripting for application performance, system maintenance and backup.
• Performed T-SQL programming for writing stored procedures, user-defined functions, Triggers, Cursors, Views on SQL 2000 servers.
• Installed & configured Web server IIS 4.0 and SQL Server 7.0 and hosting websites.
• Develop and create data dictionary, tables, views, indexes, and functions advanced queries for databases using Query Analyzer and Enterprise Manager.
• Developed necessary data access programs using JDBC and Data Express and developed the web pages using HTML and Java Scripting.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Configured securities and access to product databases in SQL Server 2000, Windows 2003 Server.

Environment: SQL Server 2000 Enterprise Version, SQL Query Analyzer, T-SQL, Java Script, C++ Microsoft IIS 4.0, VB 6.0, HTML, XML, Windows 2003, PERL, Shell scripting.