SUMMARY

• Multifaceted, performance - focused, and highly analytical professional with wide-ranging experience in relational database management systems and software development.
• Adept at writing complex stored procedures, functions, triggers and packages; transforming data from various data sources; and creating and developing various reports with complex formulas.
• Effective at data integration and workflow solutions; and extract, transform, and load (ETL) solutions
• Knowledgeable of Software Development Life Cycle (SDLC), Agile, and Waterfall methodologies; Oracle 9i/10g/12c Database; DDL and DML queries; and OLTP databse and OLAP; and database warehousing concepts and modeling.
• Armed with articulate communication and interpersonal abilities in establishing and maintaining positive working relationship with clients.

AREAS OF EXPERTISE

• BCP and Import and Export
• MDX and MDX Queries Development
• Dimensions and Data Source View
• Database Physical and Logical Design
• Client Products and Implementation
• User Databases Back Up and Restoration
• Data Load, Transformation, and Extraction
• Systems Analysis, Design, and Development

TECHNICAL SKILLS

• SQL Server management Studio |SQL Developer | Toad | Enterprise Manager |
• Profiler | Query Analyser
• MS SQL Server 2000/2005/2008/2008 R2/2012/2014
• Oracle 9i/10g/12c | Access
• SQL | T-SQL | PL-SQL | DB2 | DAX
• XML | HTML
• Word | Excel | Access | FrontPage
• Crystal Reports 11/10/9 | SSRS | Business Objects | Tableau | SSAS | Power BI

PROFESSIONAL EXPERIENCE

Confidential, ST Louis, MO

Database Analyst

Responsibilities:

• Determine changes in physical database by studying project requirements; identifying database characteristics, such as location, amount of space, and access method.
• Confirm project requirements by studying user requirements; conferring with others on project team.
• Developed a broad understanding of the upstream and downstream systems and processes, including impact and gap analysis of current databases and reporting systems
• Create Technical Requirements Document (TRD) and provide input related to database effort for Functional Specifications Document (FSD)
• Utilize SQL tools like SQL Developer and SQL Server Management Studio for analyzing existing data.

Confidential, ST Louis, MO

ETL Developer/ Database Developer

Responsibilities:

• Work with Data Integration Team in data migrating from various sources to a centralized SQL server warehouse database for reporting; as well as PL SQL Development Team and DB2 Team for code reviews including formulating stored procedures on critical source transactional systems utilizing WITH NOLOCK, MAXDOP, and index hints
• Develop and maintain jobs for the loading of new data in accordance to the Reporting Team requirements (data warehouse environment, we call it EDW - Enterprise datawarehouse) and also create ad-hoc and scheduled reports for users utilizing stored procedures and one time queries
• Assist Business Intelligence (BI) Team in the development and improvement of report capabilities in SSRS; as well as DBA’s and database developers in tuning queries and procedures to maintain optimal performance while handling huge data sets
• Facilitate training of new analysts and interns on SQL Server Integration Services (SSIS) and database development while providing 24/7 on-call supports for the Data Integration Team on job failures and re-runs
• Oversee the Database Development Group for the AML project (which is an SAM 8 version upgrade, whole Actimize database upgrade to 2014, and SSIS package upgrade) as a team lead
• Leading the analysis/design phases by attending leadership meetings with IT managers and business sponsors and make design decisions for the developers
• Act as a point of contact for various regulatory data requests such as FINRA AEP requests involving data coming from SQL server databases
• Provide TFS (Microsoft Team foundation server) admin services for the database development team as a build coordinator for maintaining central code repository for checkin, checkout and branching and merging operations
• Facilitate change request approvals, and attend change management review meetings for PROD deployment of code for contractors and analysts
• Received training on PL/SQL, Informatica and Tableau.

Confidential

Database Developer

Responsibilities:

• Rendered assistance in the migration of marketing database from existing vendor to a new vendor
• Troubleshot data quality issues and provided assistance in user acceptance (UAT) and parallel testing
• Made substantial contribution to jobs execution and package maintenance that was functioning nightly and delivering daily incremental loads to the new vendor
• Aligned, modified, and forwarded business rules to new vendor while supporting database model planning
• Carried out multiple tasks including generating reports from the source systems and marketing platforms at the vendor site for internal audits and data cleansing
• Verified the SQL code such as stored procedures, functions etc in vendor’s applciations to validate the functionality
• Enhanced the performance and minimized load on the servers by tuning existing SSIS packages and reports
• Acquired training on business objects and utilized WebI in creating reports

Confidential

SQL Server/Reports Developer/ Consultant

Responsibilities:

• Conceptualized and customized new and existing reports out of OLTP database systems focusing on performance and quality
• Maintained active involvement in formulating dynamic SQL scripts in the stored procedures due to obtaining reports best performance
• Effectively transformed data from flat files through existing SSIS packages modification
• Transferred classic reports from old system into new EDR reports

SQL Server/BI Developer/ Consultant

Confidential

Responsibilities:

• Developed cascaded parameters in reporting services as well as custom enhancements for the reports using .Net
• Made use of FTP task in conducting data validations and transformations, along with data staging to prevent data from coming back to investors
• Designed new database objects such as stored procedures, user defined functions, and tables for the report creation
• Assumed responsibility in developing a new relational database for migration from the old database (MARS)
• Retained existing data and operated data transfer from various servers on the staging database by creating stored procedures
• Acquired data from flat files and Oracle resources for the SQL server database through the development and alteration of SSIS packages