SUMMARY

• Over 8 years of IT experience in the use and development, design, support and migration of Microsoft SQL Server 2012/2008/2005/2000 databases.
• Designing, testing and implementation of high availability solutions for databases for large, medium and small customers.
• Experience of Server Components using .NET Framework and Visual Studio 2005.
• Experience of BI Tools like SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Experience of creating different types of Complex Reports using SSRS.
• Extensive experience in creating complex SSIS packages.
• Experience of migrating database MS - SQL Server /08 and also DTS to SSIS packages.
• Experience in SQL Stored Procedures, Triggers, Indexes, Views.
• Coding of Database objects like Triggers, Procedures, Functions and Views.
• Experience working with T-SQL programming and Architecture, and translated complex legacy process with T-SQL procedure, functions and package.
• Experience in designing logical and physical data models using ERWIN.
• Knowledge of worked with star schema & Snow-Flake Schema.
• Experience with all phases of software development life cycle (SDLC).
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

PROFESSIONAL EXPERIENCE

Confidential, NY

MS SQL Server & BI Developer

Responsibilities:

• Supporting JDA application & creating ETL process within SSIS to get the data from different legacy system RLM.
• Working on migration from RLM to SAP.
• Creating Database Objects - Tables, Indexes, Views, and User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles using SQL Server 2008R2 and SQL Server 2012.
• Working with SSRS reports and schedule them through report manager.
• Working with T-SQL in constructingTriggers,Tables, implementingstored Procedures, Functions, Views etc.
• Working with data ware house environment for Microstrategy reporting.
• Working with Data Molder to understand the Data Model using Erwin.
• Working with performance tuning.
• Working with SSIS Extract’s IS component in order to get the data from SAP.
• Working with SQL 2012 in order to build the Stored Procedure for legacy conversion.
• Working closely with Business Analyst in order to understand the requirements.
• Working with DBA in order to optimize and tuning the SQL’s.
• Creating SQL Agent jobs and SSIS packages for legacy conversion.

Environment: MS SQL Server 2008R2, 2012, SSRS Report, SSIS, Erwin, RLM, SharePoint, Erwin SQL Agent etc.

Confidential, TX

MS SQL Server & BI Developer

Responsibilities:

• Supporting reporting application & creating ETL process within SSIS to get the data from different legacy system like SIBEL, TMSACCT, T3 etc.
• Working data ware house environment & building the Ad-hoc & SSRS reports.
• Involving to working with SQL Agent, JAMS for scheduling, monitoring the ETL Jobs.
• Creating SSRS reports & deploying, scheduling them on Report manager.
• Working with AQUA Data Studio to identity the data issues & query DB2 sources.
• Supporting production issues through JIRA.
• Creating Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed Database Triggers and Stored Procedure using T-SQL.
• Monitoring performance issues within SSIS & SQL.
• Working closely with Business analysis & team to understand end-to-end requirements.

Environment: MS SQL Server 2008R2, DB2, SSRS Report, SSIS, Aqua Data Studio, SharePoint, JAMS, SQL Agent etc.

Confidential, TX

MS SQL Server & BI Lead/Developer

Responsibilities:

• Supported reporting application called Co-Investor which is built Cognos environment & supporting Netezza ETL development through SSIS.
• Created ETL process using SSIS in order to take the data for different legacy system like Netezza, excel, flat file etc.
• Involved to work with SSIS for creating staging, target environment in Netezza.
• Worked with T-SQL and NZ-SQL to cleansing, scrubbing & standardize data in staging & then load the normalize data in target.
• Maintained existing ETL packages for reporting application.
• Managed offshore team to deliver the work & get weekly status.
• Worked with TFS for managing the source code, keeping track of such things as defects, requirements, tasks & scenarios.
• Worked as data analyst to understand the data issue & comparing data with excel.
• Closely worked with Netezza ETL development & supporting production environment.
• Involved to work with BCP, Bulk Insert & export utilities within Netezza in order to export & import the data.
• Wrote efficient SQL queries in order to do proper data analysis.

Environment: MS SQL Server 2008R2, Netezza, NZ-SQL, Cognos Report, BCP, Import & Export Data, TFS (Team Foundation Server), SSIS etc.

Confidential, CA

MS SQL Server\BI Developer\Crystal Report Developer

Responsibilities:

• Supporting reporting application which is built in SAP crystal environment.
• Creating SQL objects like Stored Procedure, indexes, views, triggers etc in order to normalize the data & use across to reporting application.
• Involved to create technical specification & functional documents for reporting application.
• Creating a different kind of report in SAP crystal environment & run against infoview.
• Involving to working with INFOVIEW for scheduling, monitoring etc.
• Creating ETL process within SSIS & maintaining the ETL packages.
• Working closely with Data Dictionary in order to understand the relationship for various tables.
• Working closely with existing data warehouse & write SQL queries, ad hoc queries & stored procedure for reporting application.
• Working with SharePoint environment in order to track, monitoring, identify our issues & new requirements.
• Working as Data analyst in order to find out the data issues, problems within SQL.
• Involving to working with remedy for supporting production issues.
• Monitoring performance and optimized SQL queries for maximum efficiency.
• Implementing fine-tuning of database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2008R2, BCP, Import & Export Data, remedy, INFOVIEW, SharePoint etc.

Confidential, MI

MS SQL Server Developer\BI Developer

Responsibilities:

• Writing user requirement documents for reporting specification.
• Creating ETL process within SSIS in order to transfer or convert the data from legacy system.
• Working with SQL objects like stored procedure, indexes, views, triggers etc. for reporting purpose.
• Monitoring performance and optimized SQL queries for maximum efficiency.
• Implementing fine-tuning of database objects and server to ensure efficient data retrieval.
• Creating Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developing SSIS ETL packages to meet data flow needs.
• Creating SSIS packages in order to migrate the data from different legacy system to SQL server.
• Creating reporting application within SSRS & report builder.
• Creating indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
• Writing SQL stored procedure in order to normalize the data & using within report application like SSRS, Crystal reports.
• Creating data source for reporting services by using data dictionary.
• Involved in managing developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Supporting remedy tracking system for production issues.

Environment: MS SQL Server 2005, 2008R2, Query Analyzer, BCP, SQL Profiler, Import & Export Data, remedy, Report Builder.

Confidential, NY

MS SQL Server & BI Developer

Responsibilities:

• Gathering business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Writing user requirement documents based on functional specification.
• Designing and developing SSIS packages using stored procedures, configuration files, tables, views, and functions and implemented best practices to maintain optimal performance.
• Migrating the data from SQL server /08 and also to work with ETL process for migration.
• Involved to work with BCP, Bulk Insert & SQL Loader within TOAD in order to export & import the data.
• Involved to creating SSIS job in Autosys.
• Involved to create a simple workflow for import the data from SQL to Oracle using INFORMATICA.
• Worked on MDM implementation in order to load the data in staging to prelanding & landing tables.
• Involved to work with perforce to managing the source code, keeping track of such things as defects, requirements, tasks & scenarios.
• Created SSIS Packages usingcontrol flow transformationto generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Performing data transfer using BCP, SSIS from different legacy system to SQL environment.
• Involved to work with SCRUM based methodology in order to provide over all projects updates.
• Writing the SQL queries for the drill down reports.
• Supporting JIRA & involving to working with production issue.
• Creating DDL scripts to create database schema and database objects.
• Analyzing and extracting large datasets using SQL.
• Developed, monitored and deployed SSIS packages.
• Developing stores procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, Constraints and rules on database objects.

Environment: MS SQL Server 2008, MS SQL Server Integration/Reporting/Analysis services, .NET Framework, C#, Erwin, TOAD.

Confidential, CT

MS SQL Server & BI Developer

Responsibilities:

• Implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.
• Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record.
• Performed data transfers using BCP and BULK INSERT utilities.
• Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference.
• Involved in managing developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.

Environment: MS SQL Server 2005, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Report Builder.

Confidential, Hopewell, NJ

MS SQL Server & BI Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2005, 2008.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained client relationship by communicating the daily status and weekly status of the project.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Developed SSIS ETL packages to meet data flow needs.
• Developed complex T-SQL code for the application.
• Designed, developed and maintained the report updates.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Installed and maintained MS SQL Server 2005.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine-tuning of database objects and server to ensure efficient data retrieval.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements.

Environment: MS SQL Server 2005, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Report Builder.

Confidential

MS SQL Server & BI Developer

Responsibilities:

• Design and implemented for accounting application system for online banking like payroll, inventory, manage account, view account etc.
• Configured and administered as online banking. Also responsible for developing, deploying and testing application in local development environment.
• Involved In designing front end we using ASP.NET & C# while as a back end using MS-SQL.
• Creating Database objects including Tables, Indexes, Clusters, sequences, roles.
• Calculating and monitoring size and space for tables, clusters and indexes
• Create indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
• Developed stored procedures, functions, views and triggers.
• Implemented triggers and stored procedures and enforced business rules via checks and constraints.

Environment: MS SQL Server 2000/2005, MS Access, Query Analyzer, SQL Profiler, Import & Export Data, Report Builder.