SUMMARY

• Over 8 years of extensive experience in database design, development and administration with MS SQL Server versions 2012/2008/2008 R2/2005/2000 using SSIS, SSAS, SSRS (BI Tools) in various industries.
• Strong experience in creating T - SQL objects, working with DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Proficient in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in writing Distributed Queries between SQL Servers.
• Expert in using tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
• Handled vast financial data, expert level query optimization and performance tuning experience.
• Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities(Data Warehouse, Data mart)
• Experienced in creating SSIS and DTS packages for ETL purposes..
• Expertise in generating reports using SQL Server Reporting Services (SSRS), and Microsoft Access & Excel spreadsheet.
• Experience in creating various reports like drill down, sub reports, parameterized, multi-valued and various adhoc reports through Report model creation using SSRS.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Excellent Knowledge of Software Development Life Cycle, RDBMS, Data Warehouse & Data Modeling concepts.
• Good Business and System analysis skills to understand the requirements and customize client applications.
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

Business/Technical Skills: MS SQL Server 2012/2008R 2/ 2008/2005/2000, MS SSRS 2008/2005/2000, MS SQL SSAS 2008/2005/2000, MS SSIS 2008/2005/2000, DTS, Erwin Designer 2000, Power designer, DB2 SQL syntax, MS-Access 2000, C, C++, VB 6.0,Developer 2000, Erwin 7.3/4.2/4.2/4.0, Oracle 9i/10g, T-SQL, PL/SQL, ASP.NET,, HTML, XML, XSL, Visual Studio 2005, T-SQL, PL-SQL, Crystal Reports, ODBC, MS Office, Windows NT/ 2000 Server/ XP.

Methodologies: Agile Scrum, XP, Test Driven Development, Waterfall.

Technologies: Microsoft Visual Studio, Office, Project, Visio, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Florida, FL

SQL /SSRS Developer

Responsibilities:

• Performed data cleansing by querying tables to eliminate the bad data.
• Performed operations such as Fine-tuning highly complex TSQL stored procedures for maximum efficiency and performance
• Used SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Used multiple join statements to retrieve data from multiple tables.
• Involved in creating, Stored Procedures, and Indexes on table.
• Created User Defined Functions, indexes to generate the distinct data based on the type of the customer base.
• Worked on SQL profiler to view indexes performance to mostly eliminate table scan.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Enforced data consistency by validating results
• Tested procedures and triggers before moving into production.
• Extensively used SQL Server Reporting Services 2008 with relational and multidimensional data.
• Created reports that retrieve data using Stored Procedures that accepts parameters.
• Generated, Drill down reports and parameterized reports using SSRS to fit business requirements.
• Generated reports using SSRS, which were uploaded to report server.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Developed high level daily summary report and monthly business summary report
• Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
• Compare the discrepancies between SQL script and SSRS reports
• Performed Monitoring and Tuning Report performance.
• Used Query Analyzer and SQL Server Profiler for tuning report queries and improving performance in SQL Server.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Kept track of changes using Team Foundation Server (TFS).
• Providing consultation to other developers.

Environment: MS SQL Server 2008R2/2008/2005, SSIS,SSAS,SSRS 2008, T-SQL, Visual Studio 2010,2008, MS Office 2010 SQL Profiler, Windows 2000/2003/XP,ADO.NET 3.5/3.0,ASP.NET 3.5/3.0.

Confidential, New York, NY

SQL /SSIS/SSRS Developer

Responsibilities:

• Create data pull procedure, SSIS packages and data or evidence documentation involve with different work stream.
• Perform manual tasks (downloading data files from third party vendor website, treasury report, excreta), Generate data samples for monthly processing.
• Compare the discrepancies between SQL script and SSIS package which are transitioning from manual to automate.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Developed packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Developed packages in SSIS and DTS according to task.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Enforced data consistency by adding data viewer to the transformations and created dynamic packages by using variables to store the data into SQL.
• Involved in maintaining batch log tables and error logging tables to handle 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 mails upon package deployment.
• Migrate / redevelop Data Transformation Services (DTS 2000) packages to SSIS 2005/2008 for server enhancement.
• Migrated packages from development server to production server using package configuration.
• Conducted data import and export operations using the DTS wizard.
• Involved in creation of fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS).
• Identified and modified the Key Performance Indicators (KPIs), measures in co-ordinance with the requirement.
• Extensively used SQL Server Reporting Services 2008 with relational and multidimensional data.
• Worked on version Control using visual source safe.
• Involved in creating C# scripts using script task in SSIS
• Created dynamic reports using SSRS for the monthly connections and details of all locations, generated report models using report builder for the end users.
• Scheduling reports on a weekly basis that was generated every Friday.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
• Created User Defined Functions, indexes to generate the distinct data based on the type of the customer base.

Environment: MS SQL Server 2012/2008R2/2008, SSIS,SSAS,SSRS 2008, T-SQL, Visual Studio 2008, MS Office 2007/2003, SQL Profiler, Windows 2000/2003/XP,DTS,ADO.NET 3.5/3.0,ASP.NET 3.5/3.0.

Confidential, Philadelphia

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.
• Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.
• Designed SSIS Packages in SQL Server 2008 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2005, instances, Oracle Databases and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Configured SQL Mail agent for sending automated alerts/email.
• Developed Pl/Sql procedures & functions to support the reports by retrieving the data from the data warehousing application.
• Provided documentation for all kinds of reports and SSIS packages.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Created SQL Server Drill down, Drill through, Adhoc, Cross tab report using SSRS to fit business requirements.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Developed high level daily summary report (Flash Report) and monthly business summary report (Monthly Management Report) and distributed these reports across different business units.
• Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Gather requirements from users at chat sessions and interviews.
• Adept at preparing business requirements documents, defining project plans, writing system requirement specifications.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition SP3, SSMS, SSIS, SSRS, SSAS, BIDS, Microsoft Visual studio 2005, Windows server 2003.

Confidential, Houston, TX

SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Created SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server.
• Involved in upgrading packages from SQL server 2005 to SQL server 2008
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column.
• Wrote T-SQL queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Involved in creating OLAP cubes and dimensions for the analysis using SSAS.
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Used “SQL Profiler TSQL Duration” template for tracking execution time of TSQL Statements.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Environment: MS SQL Server 2008/2005, SSIS, SSRS, SSAS, Visual Studio 2005, VSS 2005, Erwin 7.2, Windows NT/2003,Microsoft .NET framework 3.5, C#, XML

Confidential, Boston, MA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Planned, Defined and Designed database based on business requirement and provided documentation.
• Coordinated with DBA in creating and managing tables, indexes, triggers, database links and privileges.
• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Created SSIS package to load data from staging environment to production environment using Lookup, Fuzzy Lookup, Derived Columns, Condition 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.
• 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.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• 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-2005.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports which retrieve data using Stored Procedures that accept parameters.
• Worked in writing, testing and implementation of the Triggers, Procedures, Functions at Database level and Form level using Oracle
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible to create all the SSRS report using Cube as data source.
• Performed Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: SQL Server 2008/2005 enterprise edition SP3, BIDS, SSRS, SSIS, SSAS, Oracle 10g, Windows server 2003.

Confidential 

MS SQL Server Developer

Responsibilities:

• Assisted project manager in project planning schedule for database module.
• Used highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from SSIS to make the flow of SSIS effective.
• Used multiple join statements to retrieve data from multiple tables.
• Worked on SQL profiler to view indexes performance to mostly eliminate table scan.
• Tested procedures and triggers before moving into production.
• Created various SSIS packages for data transfer and migration from OLTP to OLAP.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Analyzed and designed disaster recovery / replication strategies along with business managers to meet the business requirements.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: MS SQL Server 2005, MS Excel, Windows 97/2000/XP