SUMMARY

• Over 7 years of experience in working with Data Warehousing & Business Intelligence solution Design, in the area of specifically related to MS SQL server 2005/2008.
• Expert in extracting and transforming data (ETL) using DTS or SSIS(SQL Server integration Services).
• Expertise in SQL server database tools SQL Server Management Studio(SSMS), Enterprise Manager and SQL Server Business Intelligence Studio(BIDS).
• Good Working experience in domains Banking, Mortgage and Business sectors.
• Extensive experience as a Database Developer involving Analysis, Design and Implementation of project requirements through interacting with client and development teams for Data Modeling methodologies i.e normalization/De - normalization.
• Excellent knowledge in RDBMS concepts and constructs along with Objects creation such as Tables, Table Normalization, User Defined Data Types, Indexes, Stored Procedures, and Triggers.
• In-depth knowledge of Transact-SQL DDL and DML.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user profiles, relational database models and data integrity, SQL joins and query writing.
• Supported internal/external teams in resolving T-SQL related tuning issues and Proficiency in writing complex T-SQL Queries.
• Created SSIS packages with error handling using various data transformations like conditional split, for each loop, multi cast, column conversion, script components for elimination of duplicate Data, Null values, and converting data into required formats.
• Extensive working knowledge in converting/migrating (ETL) DTS packages into SSIS.
• Experience in migrating data from external system including flat files, excel, MS Access and Oracle into SQL Server using SSIS/DTS packages.
• Experience in Creating and Maintaining the Analysis Services Databases and Cubes using SSAS.
• Worked with OLTP, Data warehouse applications, dimensional models which include star and snowflakes schemas to implement SSAS, SSRS for supporting large Reporting needs.
• Experience with front end development technologies in .net like ASP.net,C#.net,HTML.
• Ability to adapt to fast changing environment at work.
• Excellent task oriented team player with communication, interpersonal, problem solving and analytical skills.

TECHNICAL SKILLS

DBMS/RDMBS: MS SQL Server 2012/ 2008/2005/2000/7.0 , Oracle8i/9i, MS Access,MYSQL.

ETL Tools: DTS, SSIS,SQL Scripts

Development languages: T-SQL, PL/SQL

Web development: HTML, XML,JSP, CSS(Cascading Style Sheet).

Database tools: SQL Query Analyzer, SSMS (SQL Server Management Studio), SQL Server Agent, SQL Profiler, SQL Server BI Studio, Replication, Visual Source Safe.

Data Modeling: Erwin, MS Visio, MS Power Point

Models/Framework: OLAP,ROLAP,MOLAP, star schema.

Programming languages: C, C++, VB 6.0, ASP.

Reporting tools: SSRS (SQL Server Reporting Services), Crystal Reports, MS Excel- 2000/2003/2007/2010.

ERP Applications: SAP, peoplesoft.

Operating systems: Windows 98/NT/Server 2000/Server 2003, Windows XP/Vista/7, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Texas

SQL Server SSIS Developer

Responsibilities:

• Participated in the Client meetings from starting to gather all the requirements from various business perspectives.
• Actively participated in database modeling and gathering System Specification as required.
• Used SSIS to create ETL packages to validate, Extract, Transform and load data into ODS.
• Involved Extract, Transform and Load (ETL) process Framework.
• Developed, Tested and Maintained the T-SQL Code in terms of Stored Procedures, Triggers, and User defined Data types.
• Loaded the Collateral source system to EDW using SSIS, T-SQL.
• Developed SSIS packages using different types of Error Handling for various events.
• Created and deployed SSIS packages according to business rules.
• Worked on DTS Packages, Import and Export Wizard for transferring data from heterogeneous database (DB2, Textfiles, and Excel) to SQL Server.
• Created the interdependent jobs using SQL Server Agent to call the SSIS Packages, Batch files, Stored Procedures.
• Created (ETL) SSIS Package(s) to make the process to run on daily basis including the processing the Cube.
• Involved in data replication, data migration and data integration etc.
• Experience in migrating Sql Server 2000(DTS) to Sql Server 2005(SSIS).
• Involved in user interface design and developed scripts to support client business needs.
• Perform data load into star schema and cube refresh (dimensions and measures).
• Generated Matrix reports, Drill Down, Drill Through, Sub reports, Chart reports, and Multi Parameterized reports.
• Worked with business analyst to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

Environment: SQL Server 2008/2005, SQL Server 2008/2005 Integration Services (SSIS), SSMS, MS Excel 2003, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MYSQLMDX, SQL Server BI Studio 2003/2008, VB Script, IIS, Visio 2003, Erwin, F-Secure SFTP, Microsoft Outlook 2007, IBM Sametime IM, Windows 2003 Server/XP, UNIX,Visual Source Safe, power Builder,TOAD.

Confidential, Dallas, Texas

SQL Server Developer/ETL developer

Responsibilities:

• Collecting all the requirements from various business documents and creating the initial design by interacting to clients and supervisors.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data into Data Warehouse and Data Mart.
• Extracting data from various sources like text files, excel and loaded in to the SQL Server Database.
• Did analysis considering various use case scenarios by generating the Ad-hoc reports for decision support.
• Query optimization and performance tuning and running DBCC commands for consistency check.
• Tuning the T-SQL Statements by using the Execution plan and SQL Profiler.
• Used Star Schema as part of Normalization.
• Designed process flow and data flow diagrams by using Visio.
• Creating triggers, writing stored procedures, User defined Data types and optimizing them.
• Created Clustered and non-clustered index for increasing performance.
• Creating and dropping indexes to speed up the ETL Loads and Data retrievals.
• Created (ETL) SSIS Packages to make the process to run on daily basis including the processing the Cube.
• Migrated from DTS Sql server 2000 to SSIS Sql server 2005 and 2008.
• Created and maintained Analysis Database (SSAS) and Cube using MOLAP.
• Experience with the creating star schema and snowflake schemas.
• Experience in data modeling is a huge plus.
• Experience with ER and Dimensional Modeling.
• Partitioned the Analysis Database on weekly basis to improve the cube performance and scalability.
• Created the Indexed Views to boost the performance of the query.
• Created multiple views and Queries for SSRS reports.
• Loading data from SQL Server to EDW using SSIS, T-SQL, BTEQ, and TeraData Utilities.
• Supported production environment.
• Participated in creating/enhancing the Scorecards that gets refreshed from Cube Pivots.
• Sending the Metric Scorecards to distro.

Environment: SQL Server 2005 Database Engine, SQL Server 2005 Integration Services (SSIS), SQL Server Analysis Services (SSAS),MYSQL, MDX, SSMS, MS Excel 2003, SQL Server BI Studio 2003,VB Script, IIS, Visio 2003, F-Secure SFTP, Microsoft Outlook 2003, Lotus Notes, IBM Sametime IM, Windows 2003 Server/XP, Visual Source Safe.

Confidential, Plano, Texas

SQL Server Developer/ETL developer

Responsibilities:

• Created DTS and SSIS packages for the Data Flow.
• Good experience in working with Data Transformation tasks such as Conditional Split, row count, Copy Column, Derived Column, look up, Merge and Merge Join tasks.
• Worked with different data sources like DB2, Oracle and Access.
• Created configuration files for Deployment of SSIS packages onto Different server.
• Developed T-SQL scripts to merge data into central repository.
• Developed Complex Stored Procedures and Functions for supporting efficient data storage and manipulation.
• Create User Defined Functions depending upon the requirements.
• Data loading into Tables using Stored Procedures and SSIS Packages.
• Created Views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Wrote SQL scripts to Insert, Update and Delete data in MS SQL database.
• Experience in Designing and Building the Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Involved in developing user controls and aspx pages.

Environment: SQL Server 2005/2000, SQL Server 2005 Integration Services (SSIS), SQL Server 2005 Reporting Services (SSRS), SQL Server 2000 DTS, MS Access 2003, MS Excel 2003, VB Script, IIS, Visio 2003, Zone Labs Integrity Flex, Microsoft Outlook 2003, Windows 2003 Server/XP, Visual Source Safe.

Confidential

SQL Server Developer/System Analyst

Responsibilities:

• Developed DTS packages for transferring the data between MS Excel, Flat Files and SQL Server.
• Extensively used DTS Import/Export Wizard, for performing the ETL operations.
• Involved in migration from MS SQL Server 2000/7.0 to MS SQL Server 2005, DTS to SSIS.
• Expert in writing and debugging complex stored procedures, Functions, Views and DML/DDL Triggers.
• Created stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Wrote scripts for dropping and creating referential Integrity constraints to decrease load time.
• Problem identification, troubleshooting, and index tuning the databases.
• Designed ER diagrams and mapped the data into database objects.
• Developed and maintained historical data from various heterogeneous data sources (i.e. Excel, Access).
• Enforced the Business Rules by creating constraints.

Environment: MS SQL Server 2000/2005, Windows NT, SQL Profiler, Access, Excel, Windows 2000,Query Analyzer, Enterprise Manager, Data Transformation Services (DTS).