SUMMARY

• Over 12 years of diversified IT working experience in application analysis, design, development, testing, and support of software systems, using SQL Server 2012/2008R2/2008, Oracle RDBMS, Oracle Applications 11/10.6/10.5
• Highly motivated professional - demonstrating excellent verbal communication, proven history of utilizing strong analytical skills, attention to detail, and hard working ethics to achieve high standards of deliverables.
• Excellent troubleshooting and problem solving skills, ability to prioritize multiple tasks, consistent, dependable performer working in team environments as well as ability to accomplish tasks with minimal direction and supervision.
• Worked extensively on system analysis, design, development, testing and implementation of SDLC projects.
• Capable of handling responsibilities independently as well as a proactive team member in Agile.
• Thorough understanding and experience in OLTP and OLAP systems, relational database technology, ER Modeling, star schema, snowflake schema, normalization and de-normalization principles.
• Expertise in writing T-SQL, working on SSMS, SSIS, SSRS and Data Migration projects.
• Strong knowledge in creating Indexes, Views, Triggers, common table expressions (CTE), effective Functions, and appropriate Stored Procedures to facilitate data manipulation and data consistency.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and SSIS Packages.
• Applied various transformations like Slowly Changing Dimension, Aggregate, Merge, Union All, Fuzzy Lookup, Fuzzy Grouping, Conditional Split.
• Created master and child packages, package configurations, auditing, logging and custom error handling in SSIS.
• Experience in generating reports using SQL Server Reporting Services (SSRS)
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc using the SQL Server Reporting Services.
• Highly experienced in application development using SQL, PL/SQL, Oracle Forms and Oracle Reports
• Customization/Interfacing of Accounts Payable, Accounts Receivable, Purchasing, General Ledger, Project Accounting, Inventory, Order Entry, Work in Process, Bill of Materials modules of Oracle 11/ 10.7/10.6/10.5
• Expertise in editing media files using Adobe and Final Cut Pro software.

TECHNICAL SKILLS

• MS SQL Server 2012/2008
• SQL
• Transact-SQL (T-SQL)
• PL/SQL
• C
• C++
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Reporting Service (SSRS)
• SQL Profiler
• SQL Query Analyzer
• Visual Studio 2010/2008
• SQL * Loader
• SQL *Plus
• SQL Developer
• Oracle 10g
• Oracle8i
• Oracle7
• PL/SQL
• SQL
• Oracle Forms
• Oracle Reports
• AOL
• Oracle Financials 11g/ 10.7/10.6/10.5
• Oracle Manufacturing
• MS VISIO 2003
• UML
• Windows Server- 2003/NT/XP/2000/2008
• Windows vista/7
• MS DOS
• Unix
• AIX
• Sun Solaris.

PROFESSIONAL EXPERIENCE

Confidential, Parsipanny, NJ

Data Analyst/ SQL Server Developer/ SSIS

Responsibilities:

• Currently involved in the redesign of key modules that update information on customer profile and activity in multiple databases.
• Conducted the monthly subsidy reconciliation process to accurately report business activity, while also finding ways to enhance data quality by verifying various sources of information and account for any marginal errors in a systematic manner
• Designed and built several stored procedures using SQL Server SSMS (SQL Server Management Studio) to routinely process the flow of transactional data based on business rules.
• Wrote several ad-hoc queries to better understand and direct management of data through various stages of the business process
• Conducted code walkthroughs and reviews to identify points of vulnerability in design.
• Tracked all development and data investigations through TFS (Team Foundation Server) Stories and Tasks
• Developed detail test cases, conducted UAT and post validation for all new and enhanced modules.
• Performed duties such as ‘On call” DBA while making sure issues were resolved in a timely and efficient manner.
• Involved in JAD and brain storming sessions to gather and breakdown requirements into measurebale and achievable goals and tasks.
• Designed and developed modules for loading, comparing and streamlining data into different channels to effectively reverify customer eligibility information for the National Reverification Project tailored to the FCC guidelines.
• Created job schedules in SSMS to automate manual procedures
• Applied several Back Door Updates after conducting thorough investigations into several aspects of the business activity.
• Created several database objects such as triggers, tables, views, indexes, user defined functions, stored procedures
• Performed bulk updates of data when necessary to improve functionality and performance at the same time.
• Worked with both normalized and de-normalized subsets of data for transactional and analytical purposes respectively.

Confidential

Data Analyst/ SQL Server Developer/ SSIS

Responsibilities:

• Designed and built several tables, views and stored procedures using SQL Server.
• Developed several SSIS (SQL Server Integration Service) packages and data flow tasks.
• Extracted data from different sources and stored into Staging tables in BI Staging database.
• Strong experience Creating SSIS packages to extract data from OLTP to OLAP systems (SQL Server)
• Scheduled Jobs to call the packages and Stored Procedures.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Merge, Multicasting, Conditional Split, Derived column.
• Wrote T-SQL queries, Store Procedures and used them to build packages and reports.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Worked on loading data from database to Data warehouse using SSIS packages.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.

.

Tools: & Technologies:- MS SQL Server 2012, SSRS, SSAS, Windows Server 2008, MS Office 2010, ERWIN.

Confidential

Data Analyst/ SSIS / ETL Developer

Responsibilities:

• Produced designs and created several tables, views and stored procedures using SQL Server.
• Designed and developed SSIS packages to load data to data warehouse from MDM (Master Data Management) database.
• Worked on SCD-2 (Slowly Changing dimensions) implementation for customer and products.
• Designed packages for SCD-1 and SCD-3 implementation based on business requirements.
• Extensively involved in generating reports like matrix, parameterized and drill through reports using SSRS.
• Developed stored procedures using functions to generate various kinds of reports using SSRS.
• Managed and monitored system utilization by using the query optimizer and checking the execution plan.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Analyzed the error output and error log of an automated process in case of failure of the process.
• Developed high level daily summary report and monthly business summary report (Monthly Management Report) and distributed these reports across different business units.
• Extensively involved in maintaining and updating the project documentation

Tools: & Technologies:- MS SQL Server 2012, SSRS, SSIS, T-SQL, Visual Studio 2010, MS Office 2010, Visio, DB2, Oracle

Confidential, Parsippany, NJ

SSIS/ SSRS /ETL Developer

Responsibilities:

• Worked with business users to identify the business requirements and worked in agile environment.
• Designed packages which would run dynamically in any environment.
• Created database objects such as tables, Stored Procedures, Indexes, UDF’s in SQL Server 2012.
• Developed SSIS packages to grab daily transactional data from 3 different servers using ForEachLoop transformation using single ETL package.
• Developed ETL to apply foreign exchange rates to transactions records coming from Asia, Europe to flatten data into USD.
• Designed and developed SSIS (ETL) packages (Model Package) to validate, extract, transform and load data from OLTP system.
• Designed and developed SSIS packages (Model Package) for Historical Load and Incremental Load (Daily Updates) to feed the data warehouse from different sources like Flat File, CSV Files, and Excel 2007.
• Developed Cascading, Drill-down Reports to get monthly card details and profits using SSRS 2008R2.
• Involved in scheduling jobs to call the packages and Stored Procedures as per business requirement.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity and provide additional application functionality.
• Created complex views and scripts to convert business logic for different reports.
• Transformed data from various data sources using OLE DB connection by creating various packages.

Tools: & Technologies:- Windows 7, Microsoft SQL Server 2008/2012 R2, T-SQL, Microsoft Excel, Visual Studio 2008/2010.

Confidential

Data Analyst

Responsibilities:

• Analyzed data patterns to prepare lists of astronomical data using Matrix proprietary software.
• Published excerpts with empirical evidence, tabulation of probabilities of occurrence using exact hyper-geometric values only.
• Developed custom reports using Matrix software to show history of planetary movement over the past years with focus on key angles measured from a geo-centric point of view.
• Built reports using excel for custom ephemeris measurement and graphed retrograde data with regular motion patterns for a range of periods.

Tools: & Technologies:- Matrix Astronomy Software, MySql (open source RDBMS), MS Office Suite - MS Word, MS Excel, MS Power Point, MS Visio

Confidential

Senior Consultant

Responsibilities:

• Worked as Project Lead for the purge and archival process of all financial data. The project involves analyzing archival requirements, followed by design and implementation of the procedures.
• Analyzed requirements and designed/developed data validation routines for GL interfaces to ensure data quality for inbound feeds. This process helped reduce postings to suspense accounts thus minimizing maintenance.
• Analyzed requirements for data extraction modules. Designed and built data extraction, transformation and load routines for distributing Pfizer financial data to other groups within the organization.
• Involved in the performance analysis and tuning of data extraction routines for a data warehouse. The extensive tuning effort helped reduce execution times significantly.
• Analyzed reporting requirements for end users. Designed and built several PL/SQL and SQL reports to meet the business needs

Tools: & Technologies:- RDBMS Oracle 8i, SQL, PL/SQL, Computron Legacy System, Oracle Financial Applications 11/10.5.