SUMMARY

• Over 10 Years of experience with MS SQL Server and Oracle in Development, Test and Production Environments as a database/BI developer in Financial, Healthcare, Telecommunication, Manufacturing and Banking industries. Outstanding individual contributor and team player possessing excellent written and oral communication and collaboration skills.
• Comprehensive application knowledge and sound understanding of SDLC methodologies acquired from various software development project experiences.
• Good knowledge and hands on experience with SQL Server 2005/2008 (R2)/2012 and Oracle 8/9i/10g/11g.
• Worked on different sized teams building BI data warehouse and participated through the entire process.
• Strong analytic and quantitative analysis skills with extensive ETL experience of using tools such as SSIS, Informatica PowerCenter, OWB and Data Loader.
• 5+ years of consulting experience in delivering solutions utilizing the entire Microsoft BI stack (SSIS, SSAS, SSRS).
• Experience working with Agile development methodology.
• Proven skilled problem solver that has contributed to various projects that had been successfully delivered and enhanced.
• SQL Server T - SQL, Oracle PL SQL, Stored Procedures and User Defined Functions.
• Strong and proven ability to create solutions that satisfy all stakeholders and engage in the details.
• Experience in using, configuring or tuning industry leading BI software tools in data intensive, large-scale environments.
• Solid experience in data profiling, data analysis, data quality checking.
• SQL Profiler, Query Analyzer, DTS, SharePoint, Enterprise Manager.

PROFESSIONAL EXPERIENCE

Confidential, DC

BI Developer

Responsibilities:

• Implement Agile methodology and work on daily builds, continuous development and dynamically prioritized requirements.
• Perform various tasks throughout the project, including but not limited to gap analysis, developing, testing and implementing ETL packages and creating reports.
• Develop an in-depth understanding of the underlying data and data structures.
• Identify and document the data to be added in the existing data warehouse, extracting and analyzing the logic behind each needed data element.
• Design the data structures to in corporate the identified needed data elements.
• Validate the mapping rules specified in the mapping document and create the data mapping sheets including the transformations to be applied using Informatica.
• Extract and verify the data to ensure all extracted data is prepared for the ETL process.
• Run validation scripts after source data or files being loaded.
• Load different data into data warehouse following the Sprint Task(s) planned for ongoing process scheduled.
• Document and facilitate developed components through the project including source code revision control, unit testing and change management.
• Verify all dependencies among data load workflows that have been defined in integration testing.
• Perform data verification on Data Warehouse using sample reports.
• Verify the functionality of the system meets the business specifications.
• Maintain and enhance the business intelligence database and ETL packages set-up for reports generating.
• Review queries for performance issues, making changes as needed.
• Work with DBAs to schedule ETL packages on varied schedules.
• Participated in Business Requirements discussion sessions and worked on designing and developing functional specifications.
• Analyzed source systems for data profiling.
• Studied Entity Relationship Document to understand the table structure.
• Identified the tables and data elements that are to be used in Salesforce CRM and the data that is not present in the existing legacy systems.
• Designed the source to target mapping documents as assigned for loading data from Legacy CRM systems to Salesforce CRM application.
• Extracted data from various sources such as SQL Server, Oracle, Teradata, Flat files and XML files in Informatica.
• Applied different transformations as needed on extracted data before loading it into corresponding destination as required.
• Validated mappings using Informatica debugger and obtained troubleshooting information about data and error conditions.
• Performed Unit Testing and Component Integration Testing.
• Performed end-to-end Migration process in Testing and Production environments.
• Provided assistance to QA and supported personnel as needed to determine possible issues.
• Performed ad-hoc analysis on sales and marketing data.
• Developed and maintained a suite of reports to support the sales and marketing teams.

Environment: Oracle, SQL Server, .NET 3.5, Visual Studio, Salesforce CRM, PL-SQL, C#, ASP.NET, XML, Informatica, API, TFS, Siebel, WSDL, Sandbox, UNIX, VSS, TeamTrack

Confidential, New Castle, DE

Information Technology Application Developer

Responsibilities:

• Participated in work group sessions with system users and other project stakeholders, contributing to the definition of requirements.
• Created ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Collaborated with source system development team to conduct ETL modifications in response to source system modifications, upgrades and patches.
• Designed, developed, tested and fixed ETL processes for error handling, operations logging and alerting, scheduling and job control with SQL Server tools.
• Developed BI solutions utilizing healthcare data from Electronic Medical Records.
• Documented reporting objectives and metric benchmarks, and participated in reviews of in progress solution development.
• Generated reports for internal business users or to be submitted to government agencies using SSRS.
• Interacted with vendors and organization wide internal departments regarding data issues to help improve data access, quality and integrity for reporting.
• Developed/automated analytical data reports for various departments.
• Maintained and enhanced existing medical chart software tool, adding front-end on-screen compliance, integrating reporting for clients.
• Tested and deployed jobs as daily tasks.
• Performed operational readiness duties on HIMS applications via on call rotation.
• Responsible for back up and restoration of SQL Server Reporting Service.
• Collaborated with engineers and graphic designers, analyzing and classifying complex change requests and reviewing and evaluating possible enhancements.
• Resolved incidents surrounding supported solutions, including after-hours escalations of major incidents.

Environment: SQL Server, SQL Server Integration Services, SQL Server Reporting Services, T-SQL, Excel, Quality Center, Visual Basic, ASP.NET/VB.NET/C#, Team Foundation

Confidential, New York, NY

SQL Server BI Developer

Responsibilities:

• Performed all development activities required for delivery of BI solutions including ETL, data modeling, cube development, solution deployment and maintenance.
• Responsible for data extraction, transformation and load for Trade Order Management Systems and Investment Analytic tools.
• Deployed inbound and outbound trade files.
• Responsible for the implementation, client support, upgrade management strategy of Trade order Management system for both alternative and traditional investment managers.
• Created SSAS solutions and other solutions with Excel, ad hoc studies and analysis.
• Collaborated with Technology Services Unit to help design, QA test and implement various bug fixes, patches and upgrades.
• Developed new and supported existing SSRS reports of quantitative and qualitative data produced both internally and externally.
• Tracked and reported key metrics.
• Scheduled and monitored night work processes.

Environment: MS SQL Server, Excel, MDX, Business Intelligence Developer Studio, SSAS, SSRS, SSIS, OLAP, Oracle, ETL, SAS, Regression Modeling

Confidential, New York, NY

ETL Developer

Responsibilities:

• Designed, developed, tested and fixed ETL packages utilizing Oracle Warehouse Builder (OWB) that implements ETL processes from data in multiple sources and different formats.
• Worked on data mapping from source systems to Data Warehouse and to external interfaces per business requirements and technical specifications.
• Performed data analysis, assessed data quality, performed data cleansing and developed benchmarks and reporting.
• Designed and developed data transformation procedures in Oracle PL/SQL as needed.
• Created, executed and documented unit test plans and recommended QA test plans for ETL and data integration processes.
• Communicated open items and issues to key stakeholders, including management, testing team, and product management team.
• Provided monitoring and support of existing production ETL jobs.
• Wrote database triggers in PL-SQL to check the referential integrity of the database.

Environment: Oracle 9i, Oracle Warehouse Builder, Windows XP/2000, Excel, Access

Confidential, New York, NY

SQL Server Developer

Responsibilities:

• Involved in translating Business Requirements into Functional Specifications.
• Analyzed source systems for data profiling and created source to target mapping specs.
• Leveraged data integration tools to create batch jobs for ETL processing.
• Created constraints, rules and defaults to maintain the data and referential integrity per requirements.
• DevelopedProcedures, Functionsand databaseTriggers.
• Responsible for system security and roles.
• Developed Dynamic search queries and results with test data.
• Generated and configured reports with Crystal Reports and in house application.
• Created Drill down and Drill through reports using Crystal Reports.
• Involved in the performance tuning and optimization of T-SQL queries.

Environment: SQL Server 2000, Windows XP/2000, Crystal Reports, Excel

Confidential

Technical Data Analyst

Responsibilities:

• Performed new data source ingestion processes.
• Maintained systems and applications to measure, record and report on data ingestion activities.
• Managed and monitored the use of disk space and coped with the impact of external factors on the database.
• Created analysis and visualization of business data and metrics in order to allow staff to align and track data against overall business strategies and objects.
• Processed overseas requests for matching, appending or counting.
• Uploaded business data to Worldbase and maintained business data for local database.

Confidential

Oracle Data Analyst

Responsibilities:

• Tested daily data ingestion process on UNIX servers that update accounts and securities.
• Wrote Oracle Procedures, Functions and Triggers for business applications and data conversion.
• Validated the data integration, data conversion, accounts and account positions in Oracle 8 for project development after major corporate accounts merging.
• Presented data in charts, graphs, tables, designed and developed relational databases for collecting data.
• Handled day-to-day operations work to support Market Data and research products.