SUMMARY

• Over 7 years of extensive experience in Database Design, Development and Maintenance as SQL Server Developer using MS SQL Server 2008/2012 with expertise in SSIS, SSRS and SSAS.
• Highly knowledgeable in Major Industrial Sectors such as Financial Services, Banking and Insurance.
• Superb experience in developing various Risk Reports (FX, Interest Rate, Commodity, Credit, Issuer Risk) for Market and Credit Risk Managers in Fixed Income Division using SSRS 2008/2012 specifications including Charts, Sub Reports, Drill Through, Cascading and Drill Down Reports.
• Experienced in all phases of project life cycle, starting from Business Requirement Gathering and Analysis to Testing and Deployment.
• Comprehensive in Installation, Upgrading and Configuration of MS SQL server 2008/2012.
• Extensive experience in Microsoft T - SQL, creating and optimizing all database objects — Stored Procedures, Tables, Views, Triggers, Indexes, User-defined Functions, Subqueries and Joins.
• Highly skillful in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS Packages, Query Optimization and Performance Tuning.
• Adept in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy (BCP), creating Dynamic packages for Incremental Loads and Data Cleansing in Data Ware House.
• Expert in defining and deploying MDX Cubes and complex SSAS Cubes with multiple fact measures, groups and multiple dimension hierarchies based on OLAP reporting needs.
• Proficient in design of logical and physical data modeling using Erwin data modeling tool.
• Profound understanding in defining Query for generating Drill Down Reports and handling Parameterized Reports in SSRS and sorting the data, defining subtotals for reports and designing report layout.
• Strong ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as a Lead proactive team member
• Outstanding communication and analytical skills with ability to develop creative solutions for challenging client needs

TECHNICAL SKILLS

• MS SQL Server 2012/2008
• Transact-SQL (T-SQL)
• MS Visual Studio
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Reporting Service (SSRS)
• MS SQL Server Analysis Services (SSAS)
• MS Office Suite
• Tableau.

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Created data mapping document to provide source and destination mappings for effective Enterprise Data warehouse. Involved in implementing logical and Physical Database modeling.
• Created dynamical queries, indexes, stored procedures, views, joins and User defined functions, trigger and implemented as per the business requirements for secured data storage, efficient data manipulation and troubleshooting.
• Designed and deployed various ETL packages to migrate the data coming from flat file, Excel, XML and SQL Server and to synchronize daily transaction data.
• Generated different types of reports from SQL Server and OLAP Enterprise Data Warehousing, and daily list reports by using stored procedures and Crystal Report.
• Developed and deployed Tabular Reports, Matrix Reports, Drill-Down reports, Cross-Tab Reports and Ad hoc reports by using SQL Server reporting services (SSRS).
• Maintained and modified reports by using XML for updated web data service and using Report Builder for Ad-hoc reports. Implement Dash reports to MS SharePoint for different departments.
• Scheduled and subscribed reports by using Report Server.
• Designed, implemented data mart, facts, dimensions and online analytical processing (OLAP) cubes using dimensional modeling standards, and created cubes by using SSAS.
• Set up security and perspective for OLAP cube by using SSAS.
• Deployed the cubes and verified the result on the browser. Exported cubes to Pivot Tables in Excel for business analysis.
• Planed and implement strategies of project that would ensure all the business requirements reflect in the project development. Organized project process by using MS Team Foundation Server.

Confidential, New York, NY

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Create various database objects (tables, indexes, views and stored procedures) and implemented referential integrity for enforcing business rules.
• Loading data from various sources like OLEDB, flat files, excel files to SQL Server database using SSIS package and created data mappings to load the data from source to destination.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in all the environments (Development, Testing and Production).
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Involved in optimizing slow running SQL queries to improve performance and availability by using Execution Plan and SQL Server Profiler.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Generated reports using SQL Server Reporting Services 2012 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Deployed reports on Microsoft Office Sharepoint (Moss).
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Documented all database objects, procedures, views, functions & packages for future references.

Confidential, Bloomfield, CT

MS SQL Developer/SSIS, SSRS Developer

Responsibilities:

• Developed Complex Queries in T-SQL, Stored Procedures, and Views with best execution plan.
• Created User Defined Functions, Triggers, Indexes.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Used the SSIS to migrate Databases such as Oracle and Access database, flat files to SQL server 2012.
• Developed DTS jobs to import data from legacy systems.
• Used SQL Server Mail Agent for sending automatic emails when any packages, queries are failed.
• Responsible for Developing, Monitoring and Deploying SSIS packages.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services.
• Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down and Crosstab Reports.
• Designed and developed various Service management reports, utilizing dynamic and cascading Prompts, sub-reports, charts, Formulas, parameterized reports, Navigation reports and dynamic reports using SSRS.

Confidential, Winsor Locks, CT

MS SQL Developer/SSIS/SSAS/SSRS/BI Developer/ETL Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Water Fall SDLC model system.
• Developed T-SQL Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Developed User Defined Functions for giving Scores and views for the application.
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Developed, monitored and deployed SSIS packages.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server. Created Stored Procedures for that.
• Involved in performing migration of DTS packages to SSIS packages.
• Developed Cascading, Drill-down Reports to get monthly sales details and profits using SSRS.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Recognized the fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services.
• Identified and modified the KPIs, measures in co ordinance with the requirement.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Nonclustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS.
• Executed manual test cases by using positive and negative data inputs and verified actual results with expected results. Report results and defects using Quality Center.
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS 2008.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.

Confidential

Business Analyst

Responsibilities:

• Developed database by using normalization, dimension modeling and Enterprise Manager.
• Developed complex T-SQL command in creating Tables, Constraints, Indexes and Views.
• Designed and implemented the Stored Procedures and Triggers for automating tasks.
• Used DTS for data population from different sources, created DTS packages for data conversions and loaded data from flat files and Excel files.
• Generated daily report list by using SQL queries and Stored Procedures.
• Created and automated regular jobs such as daily/ weekly report generations in Crystal Reports.