SUMMARY

• Having 10 years of total IT experience in Analysis, Design, Development, Testing and Implementation of the Data Warehouse applications and Database systems for Financial, Insurance, mortgage and agricultural industries.
• 8 years of Data warehouse experience using SSIS, SSAS, SSRS, SQL(Stored Procedures, T - SQL Queries, Functions, Triggers, Indexes and views), Data marts, OLAP,OLTP and two years of Ascential Data Stage 7.5.1.A/7.1/6.0 (Data Stage Administrator, Data Stage Designer, Data Stage Director and Data Stage Manager,) Orchestrate/Parallel Extender, Quality Stage/Integrity) experience.
• Strong knowledge of Data Mart and Data Warehouse design with Star and Snow Flake schemas.
• Extensive experience in implementing DW/BI using ETL tools like MS-SQL Server Integration Services (SSIS), Data Stage and reporting tools like Hyperion Interactive Reporting & SSRS
• Proficient in data research, analysis, design, development and implementation of business intelligence/OLAP application using ERWIN, Hyperion Essbase 9.x/7.x (cubes building), SSIS, SSRS (reports) and SSAS (cube).
• Hands on experience in Extraction, Transformation and Loading data from MS-SQL Server, Oracle, DB2, MS-Access, Excel and flat files using MS-SSIS and Data Stage.
• Good exposure in usage of different RDBMS like MS-SQL Server, IBM UDB, Oracle and MYSQL
• Good understanding on Logical (conceptual), Physical database design and Normalization.
• Hands on experience using Data Modeling tools like Microsoft Visio and Erwin.
• Hands on experience on writing T-SQL Procedures, Functions, Views and Indexes.
• Hands on experience in performance tuning of ETL jobs/packages and queries.
• Good understanding on build multidimensional cubes using MS-SSAS and power pivot using MS-Excel.
• Able to work with an aggressive, demanding project schedules and environment.
• Self-starter with strong analytical, troubleshooting skills and ability to work independently or as a team member.
• Experience on leading, mentoring teams and strictly adhering to SDLC/Agile processes.
• Ability to adapt to new skills and technologies and dedicated to maintaining high quality standards.
• Possess strong analytical, problem solving skills and flexible to work with new environments.
• Excellent team Player with very good communication and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: MS-SQL Server Integration Services 2014/2008 R2/2005, Data Stage 7.5.1

Database: MS-SQL Server 2014/2008 R2/2005/2000, Oracle 9i/8i & MySQL 5.1.MS-Access 2010

Data Modeling Tools: MS-Visio 2010, Erwin

Reporting Tools: MS-SSRS 2014/2008/2005

Analytic Tools: Hyperion Essbase, SSAS

Operating Systems: Windows 2000/XP/7, Windows Server 2003/2008, Linux, UNIX

Scheduling Tools: Windows Scheduler, MS-SQL Agent, Control M, DataStage Director

Project/Process Management: TFS, Tortoise SVN, MS-Visual Source Safe, Bugzilla, and Version One

Business Tools: MS Word, Excel, Power Point, Outlook

Languages: T-SQL, PL/SQL, C, Java, Servlets and JSPs

Internet Tools: IIS, FTP, TCP/IP, SFTP, WinSCP

PROFESSIONAL EXPERIENCE

Confidential

Sr.SQL/BI Developer

Responsibilities:

• Analyzing, understanding the requirements and creating strategies and define business rules for source to stage & stage to target for each source.
• Complex logics are implemented in stored procedures and created SSIS packages for data transformation.
• Responsible for executing and delivering the projects in parallel.
• Responsible to implement the monthly process to the EIS (Executive Information System) for the processed transactions through settlement platform, apply the percentage of payment to the sponsors and create the report for sponsor wise.
• Responsible for work distribution, monitoring the deliverables and coordinating financial analysts and business Analysts.
• Creating and reviewing fulfillment deliverables and communicating deliverables to the corresponding stake holders.
• Participating in the discussions with stake holders to validate the business needs and the requirements.
• Responsible for the data quality testing and correct the data in case it has any discrepancy and re run the process.
• Created the SSRS report for Payment Instruction file to pay seller payments by the sponsor banks.
• Re-written the stored procedures while upgrading the server from SQL server 2008 R2 to SQL server 2014 for the incompatible functions (COMPUTE, RAISERROR) and modified the ssis package from the hardcoded path to table driven.
• Prepared unit test case template and scripts for each possible scenario & documented the results.
• Created documents with deployment steps and rollback steps
• Responsible for review of stored procedures, packages, test cases and naming standards as well bug fixing.
• Responsible for Production supporting (handling the Incidents), migration support (Deployments).
• Responsible to improve the performance of Process by analyzing the data through creating the Indexes, analyzing the estimated execution plan and crating the Key s.

Environment: SQL Server 2014/2008 R2 and 2005, SSIS, SSRS,MS-Access 2010, Windows 7, TFS, Visual Studio Ultimate 2013/2010,MS - Visio 2010

Confidential, FL

SQL Jr. DBA/BI Developer

Responsibilities:

• Writing and creating data load scripts and stored procedures; ensuring that data is loaded in a timely manner and on the end-user requirements.
• Monitoring and troubleshooting SQL Jobs, DTS and Integration Services packages and Reporting services.
• Debugging and solving data integrity issues caused by application errors and handling Data requests.
• Interact with functional Architecture to validate the requirements.
• Monitoring overall database performance; identifying issues and implementing improvements.
• Design and develop T-SQL procedures, query performance tunings and SSIS packages.
• Addressing software integration issues such as database conversions, system upgrades, and platform compatibility.
• Performing production support of multiple applications.
• Develop new SSIS Packages/SSRS Reports to meet business needs.
• Profiling databases (using SQL) to troubleshoot issues, improve performance, and provide response-time enhancements.
• Migrating databases to and from different SQL Servers and Setup Transactional Replication to maintain data availability.

Environment: SQL server 2008, Business Intelligence Development Studio (BIDS), Management studio(MS ), SSIS, SSRS, SSAS,, SQL Developer, SharePoint server, visual studio, Power Shell, SQL safe lite.

Confidential, MN

SQL ETL Developer

Responsibilities:

• Responsible to gather the information from strategic management team and develop or modify the requirements and make them into design and development documents.
• Interaction with the business users to better understand the requirements and document their expectations.
• Worked with the team to design architecture and a base ETL for the project.
• Used the SSIS, SSRS, pl/sql and t-sql extensively to Transform and load data into the staging area and eventually into the Warehouse.
• Extensively used the Control flow tasks (sequence container, For loop container, Execute SQL Task, Data Flow Task, File system task, Execute Process Task and Execute Task ),
• Dataflow tasks(Flat file Source, Excel Source, OLEDB Source, lookup, Derived column, conditional Split, merge, Merge Join SCD, sort) and stored procedures.
• Worked on creating the SSRS reports and creating the process.
• Responsible for ATHENA process and handled the Revenue, sales, Acquisition, House hold and BSO.
• Handled the performance tuning of packages, jobs and database and debugged the critical business functions and handled the House hold process.
• Responsible in designing of the CASPR reports with the same logic with more flexibilities and developed the mapping sheet to design the Datastage PX jobs.
• Extensively used Share point server for documentation and AUTOSYS to schedule the jobs.

Environment: SQL server 2005, Business Intelligence Development Studio (BIDS), SSIS, SSRS, Datastage PX 7.5, oracle, windows server 2005/xp, SharePoint server (portal), ATHENA, RAdmin tool, SQL navigator, Management studio, C++, NDM.

Confidential, MN

BI Developer

Responsibilities:

• Need to extract the data from Hyperion Essbase cube and load into the flat files based on month.
• Written the report scripts on Hyperion and created the schema for the new structure (snow-flake schema).
• Performed the ETL operations by creating the packages to load the data from flat files to tables.
• Manage a team of database developers to support the Business Intelligence and data services needs of the enterprise.
• Created the cube using SSAS and processed the data.
• Experience in working share point server to maintain the documents, updating the document library creating.
• Exported the historical data (Level0) from Hyperion Essbase 6.5.1 by writing the report scripts for past five years and loaded it into the flat files.
• Loaded the flat files data to database tables (SQL server 2008) by developing SSIS package and created the relationship between the fact and dimensions.
• Create prototype SQL Server 2005 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM)
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
• Developed the web based reports using SSRS and deployed the reports (.rdl files) in to server system, tested the reports
• Worked on developing the data warehouse interfaces with Accounting Systems and equity.
• Involved in developing the reports using voyager.
• Involved in Database administration tasks like creating databases, tables, backups, user mapping etc.

Environment: SQL Server 2008 (Management Studio, Business Intelligent Studio, SSIS, SSAS, SSRS), BIDS, Oracle 8i, windows server 2003, Hyperion Essbase 6.5.1, Erwin, Applied OLAP, Share point server, BizTalk, Autosys, Business Objects voyager.