SUMMARY

• Overall 8+ years of IT experience with 7+ 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.
• Good Business and System analysis skills to understand the requirements and customize client applications.
• Excellent Knowledge of Software Development Life Cycle, RDBMS, Data Warehouse & Data Modeling concepts.
• 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).
• Strong experience in creating T - SQL objects, working with DDL/DML, performs 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 huge financial data, expert level query optimization and performance tuning experience.
• Strong Experience with Business Inelegance Studio 2005.(SSIS/SSRS/,SSAS)
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• 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.
• 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

• 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.

PROFESSIONAL EXPERIENCE

Confidential, Norwalk, CT

SQL /SSIS/SSRS/SSAS Developer

Responsibilities:

• Created data pull procedure, SSIS packages and data or evidence documentation involved with different work stream.
• Performed manual tasks (downloading data files from third party vendor website, treasury report, excreta), generated data samples for monthly processing.
• Compared 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.
• 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.
• Migrated packages from development server to production server using package configuration.
• 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 containing the details of weekly sales for our location for assessing the business for that week.
• 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,ADO.NET 3.5/3.0,ASP.NET 3.5/3.0.

Confidential, New York, NY

SQL Server /SSIS/SSRS/SSAS 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, Montvale, NJ

SQL Developer/SSIS/SSRS/SSAS 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.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• 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.
• Configured SQL Mail agent for sending automated alerts/email.
• Gather requirements from users at chat sessions and interviews.
• Adept at preparing business requirements documents, defining project plans, writing system requirement specifications.
• 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.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• 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.
• Worked with SAP consultants to develop reports.

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

Confidential, New York, NY

SQL Server/SSIS/SSRS/SSAS 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, Jersey City, NJ

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

Confidential, Denville, NJ

SQL Server Developer

Responsibilities:

• Installed and configured MS SQL Server and Applied service packs and hot fix.
• Migrated databases from SQL server 2000 to SQL server 2005.
• Logically and physically designed database for projects on basis of user requirements using ERWIN.
• Wrote various Stored Procedures for the purpose of application development.
• Performed Database backups (operating system, flat file backups & export/import).
• Created complex Stored Procedures.
• Used Query Analyzer to optimize SQL Queries.
• Converted various SQL statements into Stored Procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time).
• Coded Procedures & Functions in MS SQL server 2005.
• Successfully loaded data from an EXCEL, Access into a SQL Server database Table.
• Loaded data from Flat files (. txt) into SQL Server Using SSIS 2005.
• Involved in query monitoring for the queries that were parsed through Cogon’s.
• Provided technical support to internal developers and external clients Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2005/2000, T-SQL, Enterprise Manager, Windows 2000 Server, MS Office 2000, Erwin.