SUMMARY

• Around 10 years of IT experience in database development, design, analysis, support of MSSQLServers 2005, 2008, 2012 in development, testing and production environments with various business domains like Manufacturing, SCM & Finance.
• SSIS, SSRS, OLAP & OLTP
• Exposure in Data Modeling, Database Design, Data warehousing & Dimensional Modeling (OLTP & OLAP)
• Involved in the data analysis for source and target systems. Good understanding of Data warehousing concepts, Business Intelligence
• Created ER - diagrams and multidimensional data models, reports and diagrams for marketing.
• Conduct data model reviews with project team members.
• Ensure data warehouse and data mart designs efficiently support BI and end user
• Expertise in scripting T-SQLqueries, Complex Stored Procedures, User Defined Functions (UDF), Database Triggers, using tools likeSQLProfiler.
• Experience in Monitoring, Job Scheduling, Troubleshooting, Back Up, Recovery and Restoration in SQL.
• Strong experience with analyzing query plans, managing indexes, Performance tuning of complex SQL queries, Normalization and Backup & Restore.
• Expert in creating stored procedures for generating reports usingSQLServer Reporting Services (SSRS) and expertise in creating complex reports using SSRS.
• Experience in creating parameterized, cascading parameterized, drill-down, chart, Indicators, drill-through and sub-reports using SSRS.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling Sub Reports in SSRS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into MSSQLServer
• Experience in working with script task with C# code and included HTML
• Involved in creating Technical documents and analysing Functional specification documents.
• Experienced in working with Microsoft Visual Source Safe (VSS) and Team Foundation Server (TFS).
• Effective in working independently and collaboratively in teams. A proactive learner with a flair for adopting emerging trends and addressing industry requirements to achieve organizational objectives.
• Having H1B valid visa, at present working in Miami, FL

PROFESSIONAL EXPERIENCE

MSBI Senior Developer

Responsibilities:

• SSRS reports - Created complex reports including Tabular & Matrix report - included HTML tags in reports
• Involved in Requirement gathering and documenting functional and technical requirements
• Creating Index, Views, Complex Stored Procedures, and appropriate User defined functions to implement the business logic.
• Created, Maintained & scheduled various reports in SSRS like Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Using Try Catch to write logic separate action and error handling code
• Creating complex queries in SQL to fetch data from existing wholesaler distribution center tables.
• Responsible to tune ETL procedures and schemas to optimize load and query performance
• Requirements gathered from clients and documented
• Delivering the requirements to the offshore team mates.
• Involved in preparing design document, functional requirements & specification document.
• Involved in unit testing, system testing and beta testing with customers.
• Mentoring team mates at offshore and reviewing their code.

Confidential

MSBI Developer/ SQL Developer

Responsibilities:

• Involved in Requirement gathering and documenting functional and technical requirements.
• Creating Index, Views, Complex Stored Procedures, and appropriate User defined functions to implement the business logic.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Developed, deployed, and monitored SSIS Packages.
• Created, Maintained & scheduled various reports in SSRS like Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Using Try Catch to write logic separate action and error handling code.
• Responsible to tune ETL procedures and schemas to optimize load and query performance.
• Requirements gathered from clients and documented

Confidential

Responsibilities:

• Created reports using SSRS & Crystal 8.0 & testing the reports based on the test cases.
• Created Complex SSRS reports using functionalities like combined queries, sub queries, unions & intersections, slice and dice, drill down, cross tab etc. to help the management to track and lead the initiates to run the process smoothly.
• Created SSIS packages to get source from various versions to SQL
• Part of the ETL team to get the data loaded in the target systems.(SSIS)
• Following the production implementation, I was involved in support & maintenance of the project deliverables. (DTS Defect tracking system, based on tickets)

Confidential

Responsibilities:

• New Development and also Performance tuning activities
• Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Experience in troubleshooting SQL Server configuration issues.
• SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Worked on SSRS extensively to create and design reports.Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
• Involved in Report server set up and deploying, configuring and managing reports using Report
• Manager and Report Builder.
• Designed ETL packages dealing with different data sources (SQLServer, Flat Files and Access) and loaded the data into target data sources by performing different

Confidential

Responsibilities:

• Involved in creating Stored Procedures and Table Designs
• Performance Tuning
• Technology/Tools: SSIS, MS SQL Server 2008 and 2005, T-SQL, SSRS, control-m, service now
• Involved in the data analysis for source and target systems. Good understanding of DB concepts, Business Intelligence
• Experienced in ETL using SSIS. Also can perform SSIS package support activities.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• 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) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in Performance Tuning and Query Optimization.
• Experience in knowledge management & training.
• Proven ability to quickly adapt to customer’s project execution methodology and in building rapport with project stakeholders.
• Excellent presentation, analytical, documentation and interpersonal communication skills
• Excellent organizational skills including ability to multi-task and prioritize and manage increasingly complex issues.

Confidential

Responsibilities:

• Analyzed the business requirements, designed and developed the Web site.
• Rebuilding Indexesand Tables as part of performance tuning exercise
• Involved in database object creation like tables, indexes, triggers and stored procedures
• Designed Reports in SSRS, using Shared data source and specified data source.
• Involved in peer review and peer testing.
• Written complex stored procedures and user defined functions, Dynamic SQL meeting the requirement
• Created scripts for data transfers
• Involved in Requirement gathering and documenting functional and technical requirements

Confidential

Responsibilities:

• Involved in developments like stored procedure, view, functions and Performance tuning activities
• Specification analyzes and reviews with peers and doing development.
• Mainly involved in Table design
• Development/Testing/Scheduling of reports & the building of the functional & design documents.
• It involved analyzing all the existing data loads to identify the cause of the performance issue and data inconsistencies and redeveloping the reports.