SUMMARY

• Strong experience in ETL, business Intelligence, analytics and reporting platforms (e.g. SSIS, SQL, Datastage, Tableau etc), predominantly in the banking industry.
• Experience in a reporting and analysis role with strong quantitative and analytical skills and a proven track record of turning large amounts of multi - faceted data into meaningful information.
• Experience using relational database systems (data warehouse) and optimizing SQL queries with strong skills in writing advanced SQL functions and procedures.
• Experience with databases including SQL coding across standard commercial databases (e.g. SQL Server, Oracle, DB2, Netezza, MySQL etc.)
• Experience in migration of data from Oracle, Flat file, Excel to Microsoft SQL Server by using SSIS and DTS utility
• Hands-on experience with relational databases and data visualization tools to deliver results.
• Expert knowledge of Excel VBA programming and PowerPoint for effective presentations.
• Working knowledge of business intelligence tools such as OBIEE, Tableau.
• Awareness and desire to work with complex data analytics, data products, and big data technologies.
• Project experience with the proven ability to work on multiple projects concurrently leveraging excellent organization and time-management skills.
• Experience providing business-related/and or technical subject matter expertise on large, highly complex reporting projects and business analytics to support management, multifunctional departments, staff members, and peers.
• Extensive experience in Database activities like Data Modeling, Database design, development, database creation and maintenance, performance monitoring and tuning, and troubleshooting.
• Strong team player with excellent problem-solving skills and ability to take new roles, self-starter with excellent communication skills.
• Experience working with cross-functional teams to create specifications for reports and analysis based on business needs.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, VBA, UNIX Shell Scripting

Operating System: UNIX, LINUX, Windows 7

Databases: MS SQL Server 2012/2008, Oracle 12c/10g, Netezza, DB2

ETL Tools: MS SSIS 2008/2012, DTS, DataStage 9.1/8.7

BI Tools: Tableau 8

Web Technologies: HTML, XML, CSS, PHP

Scheduler: Autosys

PROFESSIONAL EXPERIENCE

ETL Developer/Data Analyst

Confidential, White Plains, NY

Responsibilities:

• Worked as a Data Operations Specialist for Deposit Payment Studies validating Deposit account, transaction data extensively using T-SQL.
• Run and monitor the Data warehouse process for consumer banks from beginning to end, including ETL using MS SSIS, data validation using T-SQL, report generation and writing the cover letter which involves explanation in trend of revenue performance metrics.
• Timely delivery of revenue performance reports to clients.
• Developed VBA macros compatible with adobe version 5.0 to combine RPM pdf reports, thereby automating report generation.
• Developed SQL server agent jobs which has SQL embedded with XML. This informs the team on the list of raw tables loaded in the database. In turn, it helps in triggering processes early and reach out to clients on missing files, thereby speeding up the whole reporting process.
• Managed a high-volume workload within a deadline-driven environment.

Environment: MS SQL Server Integration Services 2008/2012, MS SQL Server 2012,2008 R2, VBA, Advanced SQL.

ETL/VBA Automation Specialist

Responsibilities:

• Worked Cross functional across Deposit Account Payment Studies Team and Benchmarking and Reporting Team.
• Creation of Benchmark charts using MS Excel with data pulled from MS SQL Server for 19 banks on their product offerings.
• Creation of ETL package using SSIS ETL tool for custom creation of benchmark table based on bank’s benchmark product.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Developed VBA subroutines for automation of benchmark reports.
• Developed VBA subroutines for generation of Cap Analysis Template.
• Certified in Lean Six Sigma Yellow Belt offered by Verisk Analytics.

Environment: MS SQL Server Integration Services 2008 R2, MS Excel 2008, VBA programming.

Confidential, NY

Responsibilities:

• Developed Datastage Sequence jobs to automate NYU Department Metrics Reporting.
• Set up University Data Warehousing to handle late arriving dimensions.
• Optimized performance of usage tracking table by creating indexes and partitions.
• Developed parallel jobs to perform Incremental Load.
• Developed sequence jobs to automate ETL and update statistics into load statistics table.
• Developed parallel jobs and executed python file through Unix shell script as part of learning analytics and loaded in Oracle tables.
• Maintain OBIEE Technical documentation for NYU University Data Warehousing.
• Provided User Acceptance Testing for OBIEE Reports.
• Provided support on Tableau Dashboards for NYU Student data.

Environment: Confidential Info sphere Data stage 9.1, OBIEE 11g, Tableau 8, Unix Shell Scripting Confidential India Global Business Services Pvt. Ltd, Chennai, India July 2013 - Dec 2015 ETL Migration Developer

Confidential, NC

Responsibilities:

• Performed Data Migration for Confidential on their banking information System: Global Wealth Investment Management Data Provisioning Point.
• Migrated 670 plus jobs from Datastage 8.1 to 8.7 Grid.
• Deployed autosys jills for executing jobs in 8.7 lower environments.
• Executed jobs in all environments through autosys scheduler and fixed warnings for job issues.
• Performed ETL testing for jobs through SQL analytic functions and through unix commands.

Environment: Confidential Infosphere DataStage 8.7, Autosys Scheduler ETL Developer

Confidential

Responsibilities:

• Created Source to Target mapping documents and developed DataStage jobs for the financial general ledger data as part of their finance data management site.
• Performed ETL testing for Manual Adjustment Entry module in SIT cycles for components through SQL query execution.
• Involved in GUI Testing. Executed test steps for varied scenarios of Manual Adjustment Entry module in HP Quality Centre tool.
• Collaborated with Business Analyst to comply with specific requirements and fixed defects.

Environment: Confidential Infosphere Data Stage 8.7, Oracle 10g, HP Quality CentreETL Automation Quality Analyst

Confidential

Responsibilities:

• Performed Function Verification Testing for BDFS stage, ODBC and Netezza Connector in Datastage 9.1.2 and Amazon S3 Connector in Datastage Picasso.
• Automation run through ATF and CLI framework.
• Performed Sanity and Regression tests on the modified builds and data verification in Big Insights for BDFS and in Amazon Web Services for Amazon S3 Connector.
• Ensured high SQA practices throughout with Confidential’s Combinatorial Test Design tool FOCUS.
• Performed Global Verification Testing for DB2, Java, BDFS, Teradata, Netezza Connectors to conform in Japanese Language.
• Honoured with Performance from Confidential India during the year 2013.

Environment: Confidential Infosphere DataStage 9.1.2