SUMMARY:

• Total 8+ years of experience in developing Database, ETL & Reporting projects. The first 2 years, I worked on Oracle database and in the recent 5 years, I have been working on Sql Server Databases, Integration Services & Reporting Services (SSIS/SSRS/SSAS,MS SQL) and strong background in SQL Server 2014/2012/2008 R2/2008/2005, stored procedure development and triggers.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Good knowledge in developing and designing reports through SSRS and Excel.
• Expert in Ad - hoc reports, drill down and drill through reports and cross tab reports using SSRS.
• Application Servers like IBM Web Sphere, Web Logic, Jboss.
• Excellent in scripting UNIX and LINUX commands.
• Worked with scripting languages like HTML 5, CS 3 S, XML.
• Expert in Autonomous Transactions, Materialized Views, Bulk Collects and Collections in Oracle.
• Experience in Performance Tuning using DBMS PROFILER, SQLTRACE, EXPLAIN PLAN & TKPROF with the help of Hints, Partitioning, Bulking techniques, FORALL and Indexes.
• Excellent Database administration(DBA) skills including user authorizations, Database creation, Tables, indexes and backup creation.
• Automated hot backup using a combination of incremental, differential and full RMAN backups(DBA).
• Used Datapump to export data from production Database to test Database.
• Created EAR using advanced java and deployed the EARs in Weblogic and Websphere servers.
• Good knowledge of soap & restful web services.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

DATABASE: Microsoft SQL Server 2008, MySQL 4.x/5.x, Oracle 10g, 11g, 12c, DB2

OPERATING SYSTEMS: WINDOWS XP/Vista/Windows 7, LINUX AS3.0 & 4.0

ETL Tools: SQL Server Integration Services (SSIS), DTS

Reporting Tools: SQL Server Reporting Services (SSRS)

Web services: Soap, Restful

Languages: C, C++, Java

Web Technologies: XML, HTML5, CSS3, Bootstrap, Javascript

Application Servers: IBM Websphere, weblogic, Pramati, JBOS servers

Development Tools: Business Intelligence Development studio, SQL Profiler, Query Analyzer, 10.6, SQL Developer, PL/SQL developer, SQL*PLUS, SQL Navigator, BIDS

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Georgia

Data Scientist

Responsibilities:

• Worked as a Data Modeler/Analyst to generate Data Models using Erwin and developed relational database system.
• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Extensively worked on Data Modeling tools Erwin Data Modeler to design the datamodels.
• Designedmapping to process the incremental changes that exists in the source table. Whenever source data elements were missing in source tables, these were modified/added in consistency with third normal form based OLTP source database.
• Designed tables and implemented the naming conventions for Logical and Physical Data Models in Erwin 7.0.
• Provide expertise and recommendations for physical database design, architecture, testing, performance tuning and implementation.
• Designedlogical and physical data models for multiple OLTP and Analytic applications.
• Extensively used the Erwin design tool &Erwin model manager to create and maintain the DataMart.
• Designed the physical model for implementing the model into oracle9i physical data base.
• Collaborated the data mapping document from source to target and the data quality assessments for the source data.
• Used Expert level understanding of different databases in combinations for Data extraction and loading, joiningdata extracted from different databases and loading to a specific database.
• Co-ordinate with various business users, stakeholders and SME to get Functional expertise, design and business test scenarios review, UAT participation and validation of financial data.
• Designed and developed UseCase, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.

Environment: SQL Server 2008R2/2005 Enterprise, SSRS, SSIS, Crystal Reports, Windows Enterprise Server 2000, DTS, SQL Profiler, and Query Analyzer.

Confidential, Ann Arbor, Michigan

Data Scientist

Responsibilities:

• Data collection, Cleaned, filtered and transformed data to specified format.
• Created captivating interactive visualizations and presentations to enhance decision making capabilities by the management.
• Developed novel applications of classification, forecasting, simulation, optimization, and summarization techniques to enhance effective decisions.
• Prepared the work space for Markdown. Accomplished Data analysis, statistical analysis, generated reports, listings and graphs.
• Used R and Python to identify drug performance via Classification, tree map and regression models along with visualizing data for interactive understanding and decision making.
• Found outliers, anomalies, trends in any given data sets.
• Assisted in migrating data, data pump with the Export/Import utility tool.
• Provided daily change management process support, ensuring that all changes to program baselines are properly documented and approved, maintained, managed and issue change schedules.
• Developed, installed, maintained and monitored company databases in high performance/high availability environment with supported configuration, performance tuning to ensure optimal resource usage.
• Redefined many attributes and relationships and cleansed unwanted tables/columns using SQL queries.
• Utilized Spark SQL API in PySpark to extract and load data and perform SQL queries.
• Visually plotted data using Tableau for dashboards and reports.
• Implemented statistical modeling with XGBoost machine learning software package using R to determine the predicted probabilities of each model.
• Delivered the results with operation team for better decisions.

Environment: Erwin r9.0, Informatica 9.0, ODS, OLTP, Oracle 10g, Hive, OLAP, DB2, Metadata, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro. Hadoop, PL/SQL, etc.

Confidential, Santa Ana, CA

Data Scientist

Responsibilities:

• Responsible for performing Machine-learning techniques regression/classification to predict the outcomes.
• Responsible for design and development of advanced R/Python programs to prepare transform and harmonize data sets in preparation for modeling.
• Designed the prototype of the Data mart and documented possible outcome from it for end-user.
• Involved in business process modeling using UML
• Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server
• Created PL/SQL packages, Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Participated in Business meetings to understand the business needs & requirements.
• Prepare ETLarchitect& design document which covers ETL architect, SSIS design, extraction, transformation and loading of Duck Creek data into dimensional model.
• Provide technical & requirement guidance to the team members for ETL -SSIS design.
• Participated in Business meetings to understand the business needs & requirements.

Environment: Machine learning, AWS, MS Azure, Cassandra, Spark, HDFS, Hive, Pig, Linux, Python (Scikit- Learn/Scipy/Numpy/Pandas), R, SAS, SPSS, Mysql, Eclipse, PL/SQL, SQL connector, Tableau.

Confidential, Stamford, CT

Oracle DBA

Responsibilities:

• 24x7 support for Production databases and applications
• Installation, configuration and administration of Oracle 10g/11g databases
• Implemented Oracle 10g RAC, 11g RAC and Standby Databases including Active Data Guard for High Availability and Disaster Recovery.
• Performed database Cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgradation and Migration of Database from 9i to 10g and 10g to 11g, applying patches whenever required.
• Developed physical and logical models of the databases using ERWIN
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Replication using Golden Gate
• Managing OLTP/Data Warehousing Databases
• Logical, Physical Database Design, Normalization.
• Developed PL/SQL Functions, Procedures Packages and Triggers.
• Importing data from flat files into database using SQL loader and External Tables.

Environment: Oracle 11g RAC/10g RAC/9i, Sun Solaris, Red Hat Linux, HP-UX, Windows, OEM(Grid Control), SQL, PL/SQL, TOAD, RMAN, ASM,TKPROF, STATSPACK AWR, ADDM, SQL* Loader, ERWIN.

Confidential

PL/SQL Developer

Responsibilities:

• Working with cross-functional teams studying the impact analysis and was involved in converting the business requirements into technical design document.
• Responsible for design, development & implementation of the database schema, creating Fact Tables and Dimension Tables using Oracle Designer 6i according to design meeting business requirements.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, triggers, packages, stored procedures, roles and granting privileges.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Involved in scheduling the batch jobs using Autosys.
• As a part of the Ad-hoc Reporting involved in Collecting report requirements from the cross-functional teams and providing the decision supporting reports, performing analysis of the reports and presenting to the managerial staff.
• Involved in creating crystal reports on demand.
• Involved in the Error Diagnosis, developing test plans to conduct the Unit and Integration testing.
• Worked closely with Business Owners to make sure requirements where converted correctly to Functional Specs and the correct logic was implemented in the technical design and code.
• Documenting the procedures for Requirement definition, Technical application design, migration, new business rules implemented and code developed and modified.

Environment: Oracle 10g, Oracle9i, Oracle Designer 6i, SQL, PL/SQL, SQL*Navigator, UNIX shell scripting, PERL, Autosys and Windows XPs

Confidential

Jr. PL/SQL developer

Responsibilities:

• Participated in analysis, design, development, testing, and implementation of various financial Systems using Oracle 8i, Developer 2000 and PL/SQL.
• This system consists of the various functional modules: Loan approvals, Deposition of Cash/ Withdrawal of Cash, Change of personnel Information, Bank Details, balance Sheet, Customer Information Database.
• Define database structure, mapping and transformation logic. Creation of External Table scripts for loading the data from source for ETL (Extracting Transforming and Loading) Jobs.
• Wrote UNIX Shell Scripts to run database jobs on server side.
• Developed new and modified existing packages, Database triggers, stored procedure and other code modules using PL/SQL in support of business requirements.
• Worked with various functional experts to implement their functional knowledge into business rules in turn as working code modules like procedures and functions.
• Used TOAD and SQL navigator extensively.

Environment: Oracle 8i, SQL, PL/SQL, UNIX.