PROFESSIONAL SUMMARY:

• MS SQL Server Developer 2012/2008R 2/2008/2005/2000 with 7+ years of IT experience in various Industry verticals like Finance and Service. Maintained positive communications and working relationships at all business levels.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Extensive experience in MS SQL Server 2012/2008R 2/2008/2005/2000, Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from heterogeneous databases such as Oracle, Flat Files, Excel Sheet and MS Access.
• Proficient in Creating, Configuring and Fine - tuning SSIS packages, SSRS reports and Confidential -SQL queries using tools like SQL Profiler, Performance Monitor, and Database Engine Tuning advisor.
• Strong experience in designing and developing enterprise reports (SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes, and various heterogeneous data sources.
• Expert in creating MOLAP Cubes using SSAS and created multiple cubes with dimensions and facts.
• Highly experienced in optimizing MOLAP Cubes by partitioning them, designing Aggregations, and implementing Hierarchies and Calculated Members.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects and Creating Calculate member using MDX in SSAS 2008/2005.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting data, defining data source, and subtotals for the reports using SSRS 2008/2005.
• Experienced in Logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, and Windows performance monitoring and SQL Server performance tuning.
• Highly proficient in using Confidential -SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models, Data Integrity, SQL joins, and Query Writing.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.

TECHNICAL SKILLS:

• MS SQL Server 2012/2008R 2/2008/2005/2000
• MS SQL Server 2010/2008/2005 Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• Microsoft Access 2010/2007/2003
• Microsoft Excel
• Outlook
• MS SQL Profiler
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• Erwin Data Modeler 4.2/4.1/4.0
• Excel VBA
• Crystal Reports 8.5
• Confidential -SQL
• MS Visio 2003
• Windows 2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation
• UNIX
• Perl
• VBScript
• JavaScript.

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

MS SQL BI Developer

Responsibilities:

• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources. .
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports using SSRS.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter, month, week and daily reports for all domains and published through Report Server.
• Designed and developed various reports by comparing the growth of company based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Created calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Used Visual Source safe for repository and maintaining versions.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other Confidential -SQL code and SQL joins for applications.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the Confidential -SQL statements using SQL profiler.
• Conducted user training sections and supported the requests for enhancements, modifications and new reports.

Tools: & Technologies: Reporting Services (SSRS), Integration Services(SSIS), Microsoft Performance Point Server 2007, Microsoft Share Point Server, Confidential -SQL, NET, C# MS Access and Excel.

Confidential, LongIsland, NY

SQL Server Developer/ SSIS Developer

Responsibilities:

• Planned, Defined, and Designed data based on business requirement and provided documentation.
• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008 a using Lookup, Fuzzy Lookup, Derived Columns, Conditional Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager.
• Scheduled report and exported in PDF format.
• Fine tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools: & Technologies: MS SQL Server 2008/2005, SSRS, Confidential -SQL, SSIS, Win 2008 Advanced Server, Erwin v7.

Confidential

MS SQL Server Developer/ SSIS / SSAS Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server 2008 on the production server.
• Automated the migration of data from Flat file to MS SQL Server 2008 DB using Microsoft SQL Server Migration Assistant (SSMA).
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Migrated the entire schema as well as data into MS SQL Server 2008 and also validated the migration process to ensure that it has been successfully migrated.
• Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• 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.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Defined referential relationships with the measure groups and fact tables.
• Generated automatically grouping attribute members and implemented the calculations to aggregate physical measures.
• Defined granularity within measure group and drill through actions.
• Created cube reports that can be browsed at summary level and can be drilled down to the detail level.
• Defined the browsing perspectives and browsing translations since most transactions were online.
• Documented the development work and production release for future reference.

Tools: & Technologies: Windows OS, MS SQL Server 2008R2/2012, MS SQL Server Reporting Services 2008R2/2012, MS SQL Integration Services 2008R2 /2012, Confidential -SQL, ERWIN, Microsoft Visio, SQL profiler.

Confidential, Minneapolis, MN

SQL Server Developer

Responsibilities:

• Managed Enterprise and Distributed Data Warehouses in Developmental and Production Environments using SQL 2005.
• Build and maintain complex SQL queries using Confidential SQL for data analysis, data mining and data manipulation. Organize analytical data; ensure data quality and aggregate data for strategic reporting and performance optimization on database solutions.
• Created/designed reports using SQL Server Reporting Services according to user requirements.
• Responsible for writing SQL queries, Procedures, Functions and Database triggers.
• Good Experience in Tuning and Optimization of Confidential - SQL stored procedures.
• Optimizing the current ETL process, identifying and eliminating bottle necks and decreasing data latency. Created synchronized mechanism for data management in SQL Server. Set the job dependencies of SQL jobs using MSDB objects.
• Standardized company reports by implementing SQL Server Reporting Services (SSRS).
• Deployed and Scheduled the Reports in Report Manager.
• Extensively used the SSIS package to write the data from the flat files into tables.
• Extensively used Explain Plan, SQL Optimizers, Partitioning Tables and Gather Statistics to analyze and improve the performance of the Queries.
• Different database triggers were created and stored in the database and fired off when contents of database were changed.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Involved in Performance Repository Project, where we collect data and generate report to Proactively Monitor the Servers and try to avoid any kind of Server and database related outages.
• Develop documentation of database architecture, system processes and procedures. Create, review and produce migration scripts of database objects from development to production environments.

Tools: & Technologies: MS SQL Server 2005/2000, MS SQL SSRS, SSIS, SSAS, Confidential -SQL, PL/SQL, Windows 2003 Server.