SUMMARY

• Over 7 years of IT experience in database design, development, and maintenance by using SQL Server 2008/2012.
• Experienced working in various fields like Retail Business, Banking, and Financial services.
• Strong experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and good knowledge on SQL Server Analysis Services (SSAS).
• Extensive experience in creating and maintaining database objects such as tables, views, constraints, indexed, and stored procedures. Experienced in Database Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.
• Hands on experience in working with project team using agile methodology.
• Working knowledgein Developing andMaintaining theMS SQL Server Analysis Services (SSAS) Cubes.
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Experienced in working with project team through all phases of software development life cycle (SDLC) - Feasibility study, Project Analysis, Requirements, Design, Development, Testing, Documentation, and Warranty Support.
• 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 indeveloping,monitoring, extractingandtransformingdata usingSSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data)
• Experience in improving the query performance by using MS SQL Profiler, Query execution plan.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, functions, and Indexes using T-SQL.
• Experience in maintenance and Administration ofSSISby creating Jobs, Alerts, SQL Mail Agent, and scheduleDTS/SSIS Packages.
• Expert in writing complex SQL queries involving multiple tables joins and sub queries.
• Great experience in deploying reports to the report server, scheduling the snapshot, maintaining the snapshot history, and good knowledge on creating subscriptions.
• Great understanding of Relational Database Management Systems (RDBMS).
• Great knowledge in developing SSAS dimensions, facts, and data source views.
• Great skills in gathering requirements, assessing client needs, and working in groups.

TECHNICAL SKILLS

• MS SQL Server 2008/2012
• SSRS
• SSIS
• SSAS
• MS SQL Server 2008 R2
• Business Intelligence Development Studio (BIDS)
• Report Builder
• SQL Profiler
• SQL Query Analyzer
• Import/Export
• OLAP Services
• SQL Server Agents
• SAS
• R Programming.

PROFESSIONAL EXPERIENCE

Confidential, NH

Sr SQL/ETL Developer/SSIS

Responsibilities:

• Worked with Project Manager and IT Analyst to understand business rules and to discuss gap analysis between old system and new system.
• Proactively designed, used and managed mapping overview documents to identify relationship between source and destination and to document the business process logic in the SSIS packages.
• Created a Data Elements Traceability Matrix to keep track of all data existing data elements, concepts of those data elements, and implement new concepts by assigning fields with different terminology to distinguish property of fields like mapped, unmapped, forwarded, deleted etc.
• Written T-SQL queries, stored procedures, user defined functions to implement mapping fields and remaining fields.
• Designed staging tables, temp tables to perform multiple joins, merge statements, views and aggregate functions.
• Created T-SQL stored procedures to improve the performance of aggregate queries dynamically.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse/data marts.
• Developed SSIS packages for data migration using OLEDB connection and transformation like Lookup.
• Test and Debug ETL packages and configured the packages for migration, worked with QA teams to qualify and migrate packages from staging to SIT environment

Environment: Microsoft SQL Server 2012, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), Visual Studio, T-SQL, SharePoint.

Confidential, Riverside, CA

Sr MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in creating ER diagrams and mapped the data into database objects.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.
• Created tabular, drill down and parameterized reports using SSRS.
• Migrated ad-hoc reports from excel and crystal reports to SSRS.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.
• Designed and created ETL packages in MS SQL Server using SSIS.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Configured SQL mail Agent for sending Automatic emails on Errors.

Environment: Microsoft SQL Server 2012, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, T-SQL, Microsoft Office Excel 2013.

Confidential, San Francisco, CA

Sr MS SQL Server Developer/SSIS/SSAS/SSRS

Responsibilities:

• Created Store procedures, functions and triggers for retrieval and update of data in the database.
• Designed and Implemented SSAS cubes architecture, facts and dimension tables to perform analysis.
• Generated Dynamic reports from OLAP Cubes (SSAS) using SSRS.
• Designed developed and deployed cascaded reports and Dash boards in MS SQL Server environment using SSRS and integrated to Share point server.
• Involved in Database/ table modeling and partitioning with Star Schema.
• Created dash boards to show and analyze the performance of the project.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and OLAP data marts.
• Transformed data into SQL server database using OLE DB connection by creating various SSIS packages.
• Created Data Transformation tasks like BULK INSERT to import/export data from clients
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Used SQL Profiler and SQL Query analyzer for performance tuning.

Environment: MS SQL Server 2012, Crystal Reports, MS Access, SSIS, SSAS, T-SQL, SQL Reporting server, Microsoft Office Excel.

Confidential, Rahway, NJ

MS SQL Server / BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Developed high Level Design of ETL DTS Package in MS SQL Server for integrating data from heterogeneous sources.
• Created SQL server Reports using SSRS for management. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Created Queries for generating drill down reports in SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Good experience and knowledge of working with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager.
• Created variables and defined formula to capture user responses to a prompt and to display document information for Web reports
• Collected business requirements, designed data maps and data models. Created Internal and External Design Documents and Transaction Definition Documents.
• Created report in SQL Server and deployed them on local-host for remote access.
• Tuned lots of ad-hoc queries and stored procedures, by creating indexes, making proper joins.

Environment: MS SQL Server 2008/2012, SSAS, SSRS, SSIS, T-SQL, Windows XP, Crystal Reports, Microsoft Visual Studio Team System (VSTS)

Confidential, Iselin, NJ

Sr MS SQL Server Developer/SSIS/SSAS/SSRS

Responsibilities:

• Work with key clients to support needs analysis and coordinate with senior compliance domain experts to drive requirements.
• Worked as a developer in developing relational database schema, creating complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications.
• Constructed Cubes and Deployed analysis projects using SSAS based on data volume, as well as developed of KPI’s which helped the Business users for easy understanding.
• Imported data into SQL database then using SSRS for advanced analysis and visualization by creating various tables, graphs that can be combined into dashboards and, delivered to clients and internal teams.
• Designed and created Dashboard with KPI’s, Scorecard and reports using SQL Server Reporting Services (SSRS) and Excel.
• Defined report layouts including report parameters and wrote queries for drill down repots using SSRS.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Conducted performance tuning by using SQL Profiler and index tuning.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.

Environment: Microsoft SQL Server 2008, T-SQL, SQL Server Business Intelligence Development Studio, Microsoft Office Word, Microsoft Office Excel.