SUMMARY:

• Having 8 years of experience as SQL developer. Experience in all phases of SDLC including requirement analysis, application design, development of multitier applications, testing, implementation and maintenance.
• Proficient in writing SQL, stored procedures, packages and triggers. Expertise in designing and implementing Oracle Alerts and Lookups.
• Experience in working on high - transacted OLTP systems.
• Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP).
• Expertise in performance tuning, fine tuning SQL queries for improved performance and Query Optimization.
• Worked on all kinds of dynamic SQL formats, connectivity and exception handling.
• Review project components for adherence to standards (Project plans, requirements documents, design documents, test plans and other work products as the parts of the SDLC).
• Experience in development, testing, production support and maintenance of projects.
• Creating and executing SQL queries to perform data Integrity testing on an Oracle database to validate and test data using TOAD.
• Experience in working in AGILE environment, and ability to work in pressurized environment with tight deadlines.
• Experience in core java concepts.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server R2.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• 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 in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Expert in creating Parameterized Reports. Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Experience in creating Informatica mappings, sessions and workflows using Informatica. Experience in Control-M job scheduling tool, and exposure to UNIX and Perl.
• Experience in using source code analysis tools, automated build process and unit testing, debugging.

TECHNICAL SKILLS:

Programming Languages: - SQL, PL/SQL, C, C++, Java, VB, .NET

Tools: /Utilities - SQL*Loader, SQL*Plus, SQL Developer, Putty, Forms, Toad, Autosys, Erwin Data Modeler, Tableau.

SQL server tools: -Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, Sharepoint.

Office Tools: - Microsoft Word, Excel, Outlook, Access, PowerPoint

Operating Systems: - Windows 95/98/NT/XP/Vista, UNIX

Databases: - DB2, Oracle Database Enterprise Application Server, MS SQL Server 2008 R2, 2005, 2000, SQLCMDData Modeling - Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snowflake schema, Fact tables, Dimensional tables), Entities, Attributes, E-R Diagrams.

PROFESSIONAL EXPERIENCE:

Sr. SQL developer

Confidential, Detroit, MI

Responsibilities:

• Working on DB2 platform.
• Created database tables, Indexes, triggers by writing SQL queries as per the database change request by the business.
• Created stored procedures, functions, and packages by writing SQL queries based on the client requirement as per the day to day updating of business logic.
• Worked on optimizing large complicated SQL statements to meet the client requirements.
• Created large complex SQL queries such as to pull the formulary data to generate tier level data of various kinds of formulary and benefit lists.
• Created SQL queries to facilitate the user to retrieve and create the formulary information of various drugs and plans.
• Worked on writing stored procedures and queries for migration and interim project.
• Worked on SQL performance tuning and done unit testing to check the performance when the data is migrated from Rx builder to INET SQL server database.
• Created required SQL queries to be integrated to Java code to meet the requirement for generating the user defined formulary reports.
• Deployed and done the debugging of the created stored procedures and done the unit testing.
• Coordinated with QA and Production team to make sure that we stick to the estimate for client.
• Worked on Synergy as the repository.
• Used service now tool for raising and addressing the tickets as per the requirement.

Environment: DB2, Java, Synergy ware, I navigator, Data studio, Windows, Linux, C++, service now.

SQL Developer

Confidential, Detroit, MI

Responsibilities:

• Contributed from design to implementation and maintenance phase of the application in AGILE environment/methodology.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes.
• Created packages with override functions that could be utilized by other systems that interface with this application.
• Analyzed data using complex SQL queries, across various databases.
• Created materialized views that refreshes data from other databases, via DB Links.
• Assisted quality assurance team with any functional and regression testing efforts.
• Provided assistance and support to programming team members as required.
• Performed data analysis primarily Identifying data sets, source data, source meta data, data definitions and data formats.
• Designed physical and logical data model and data flow diagrams.
• Worked on various tables to create Indexes to improve query performance. Involved in writing several queries and procedures.
• Worked with several tools to access and perform several operations on database. Experience in generating reports.
• Used joins, indexes effectively in where clauses for query optimization.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.
• Co - ordinated with multiple application development teams, since the application interfaces with multiple systems.
• Created huge volumes of test data to test heavy data loads across multiple systems / databases.
• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.

Environment: Oracle 10g, 11g, TOAD, PL/SQL, UNIX, Shell Scripting, Tableau server versions (7.0 and 8.2), UNIX Linux, Windows, java, Control-M.

SQL Developer

Confidential, Florida

Responsibilities:

• Analyzed data by creating simple SQL queries and identified fact and dimension tables.
• Designed mapping using various transformations such as source qualifier, expression, joiner, sorter, union, etc.
• Performed data analysis primarily Identifying data sets, source data, source meta data, data definitions and data formats.
• Designed Physical and Logical Data model and Data flow diagrams.
• Designed, constructed, and tested ETL processes. Created SSIS packages to extract data from the transactional and/or operational databases, transformed the data according to analytical / reporting business needs, and loaded the data into a data warehouse or data mart.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad - hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008
• Extract Transform Load(ETL) development Using SQL server 2008, SQL 2008 Integration Services(SSIS)
• Generated several drills down and drill through reports using SSRS.
• Expert in creating Star schema cubes using SSAS.
• Extensively worked on OLAP cubes using SSAS.
• Utilize templates to create Perl scripts that is used to schedule the workflows as per business requirement
• Use Control-M job scheduling tool to execute the workflow
• Create Unit test documents and process flow documents using Business Requirements and Design flows
• Co-ordinate with data architects team, to import required source and target tables from specific database schemas
• Create test data, that can be used in Unit testing most effectively
• Perform load testing, with huge amounts of data to validate the performance of mapping

Environment: MS SQL Server2005/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Windows 2008 Server, UNIX, Informatica 8.x/9.x, Web Services, Control-M.

SQL Developer

Confidential, Orlando, FL

Responsibilities:

• Going through the requirements. Developing flat file reports for transaction, card, merchant activity and merchant money settlement reporting Using PL/SQL and Informatica.
• Global IT services and solutions company providing value propositions to the clients in the areas of Banking and Financial services (BFSI) to redefine and impact the core of their businesses.
• Loading Incremental Data to fact and dimension tables.
• Built the PL/SQL (Procedures, Functions, Triggers, and Packages) and Informatica processes to summarize the data to populate summary tables which will be used for generating reports with performance improvement.
• Registration of new forms, creation of concurrent executable and concurrent programs for reports, opening up descriptive flex fields was done.
• Analyzed, developed, tuned, tested, debugged and documented processes using technologies SQL, PL/SQL, Informatica, UNIX, and Control - M.
• Tuned the application with functional Indices, Temp tables, right partitioning, data in sequence storage and avoid nulls, converting views into snap shots/tables, daily analyzing tables, with clause, window functions and avoiding full table scans, hints and explain plan and monitoring database.

Environment: Oracle 10g, 11g, TOAD, SQL Developer, Forms&Reports6i, PL/SQL, UNIX, Informatica 8.x/9.x, UNIX Linux, Windows, SVN, Control-M.