SUMMARY

• 7 years of experience in a fast - paced, high-volume environment in Data Modeling, PL SQL, ETL and BI applications
• Experience in designing database using Logical & Physical data modeling tools including Erwin / SQL developer / SQL Server 2008.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).
• Experience in implementing complete BI cycle designing, coding, implementation and maintenance involving Tableau, SSIS, SSAS and SSRS.
• Experience in creating ETL mappings in SSIS to load data from different sources to different target databases and data analysis, data profiling, data transformation, data mapping, data cleansing and data quality.
• Highly proficient in the use of SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Indexes, Relational Database models and Data integrity and SQL joins.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Good experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server Clustering.
• Experience in identifying Bottlenecks in ETL Processes, optimizing the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / DE normalization strategies.
• Extensively worked with Stored Procedures, Functions and Triggers and involved in Query Optimization.
• Created Management Reports through Tableau and SQL Server Reporting Service on demand.
• Hands on experience on Hive, Sqoop, Hue and Hive Analytical functions.
• Strong knowledge of Hadoop, HDFS, Map reduce and Tez.
• Experience on UNIX, Shell Scripts.
• Extensive experience handling a variety of different clientele through various levels of communication.
• Exceptional ability to quickly grasp and master new concepts and technologies.
• Excellent communication skills, creative problem solver, positive listener and a team player.

TECHNICAL SKILLS

Databases: SQL, T-SQL, PL/SQL, Oracle, MySQL, Teradata SQL Assistant, Aginity Netezza workbench, XQuery, Hadoop, HDFS

Tools: SSMS, SSIS, Microsoft Visual Studio, SQL Developer, TOAD, Pig, Hive, Tableau, Basex, Hue

Data Modeling: Dimensional Data, Erwin, ER/Studio, Visio, Star Schema, Snowflake, Physical and Logical

Versioning: Model Manager, SVN, TFS and VSS

Other: UNIX, Shell Script

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Data Analyst/Database Developer

Responsibilities:

• Involved in all phases of software development life cycle (SDLC) including requirements gathering, analysis, design, development, testing, implementation and deployment.
• Interpret data and analyze results using statistical techniques and provided ongoing reports.
• Conducting research about the information available from the vast range of sources in Teradata, Oracle, SQL server, Netezza.
• Using SSIS to extract transform & load source data. Filtering, Cleaning, and validating the data sources.
• Responsible for design, development and maintenance of data collection systems using Erwin Data modeler, SSIS, T-SQL, PL/SQL, SQL Server Agent jobs and Sqoop jobs.
• Responsible for ER Diagrams, Conceptual, Logical and Physical Data modeling using Microsoft Visio, CA Erwin that involved requirement analysis with business team and translating them into Technical Specs
• Normalizing existing tables, Optimizing the data collection and storage processes like loading the data at aggregate level, which reduces space and increases processing speed for analysis. Monitoring the automated loading processes.
• Generated DML/DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Extracted the data from Oracle, Teradata, CSV and Flat files.
• Optimized critical queries to eliminate Full Table scans.
• Documented versions of the data model, DDL scripts and maintained the versions and releases in repositories
• Perform ad hoc analysis to observe complex patterns and provided the summary of results with excel pivot tables, charts to show trending.
• Working closely with management to prioritize business and information needs.
• Designing solution, developing code and sustainment using T-SQL and Oracle. Testing and validating the results from the business perspective.
• Created ETL mappings in SSIS to load data from different sources to different target databases and data analysis, data profiling, data transformation, data mapping, data cleansing and data quality.
• Executing queries using Hive and developed Map-Reduce jobs to analyze data.
• Involved in creating Hive tables, loading with data and writing hive queries for generating reports, which will run internally in the map, reduce way.
• Familiarized with job scheduling using Fair Scheduler so that CPU time is well distributed amongst all the jobs.
• Utilized Apache Hadoop environment by Hortonworks.
• Involved in loading data from UNIX to HDFS.
• Created and published custom-built interactive reports and dashboards, report scheduling using data Visualization tools like Tableau server.
• Added pre-generated filters, parameters and calculated sets for dashboards and worksheets in Tableau.
• Review reports, performance indicators to locate and correct code problems.
• Locating and defining new process improvement opportunities.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Worked on optimizing and tuning the Oracle views and SQL’s to improve the performance of batch and response time of data for users.
• Provided quick production fixes and proactively involved in fixing production support issues.

Environment: SQL Server Management Studio, Microsoft Visual Studio, PLSQL Developer, ERwin Data Modeler, SQL, T-SQL, PL/SQL, Unix/Linux, Cold Fusion, Ricola, Java Script, SVN

ETL/ SQL Developer

Responsibilities:

• Created and maintained Database Objects (Tables, Stored procedures, functions) in SQL.
• Worked with complex logic which requires SQL queries with joins, window functions, date functions, inline functions, and sub-queries to generate various reports.
• Createdindexeson selective columns to speed up queries and analyses in SQL Server Management Studio.
• UsedExecution Plan,SQL Server Profilerto trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Worked closely with other developers for their SQL requirements, work with Business Analyst and end users to understand the report requirements.
• Performance Tuning already existing queries to improve the query time for faster reports.
• Worked on using all kinds of Constraints, managing Indexes, Locks, troubleshooting deadlocks and handling the Isolation Levels. Defined Check constraints, Business Rules, Indexes, and Views.
• Developed, monitored and deployedSSISpackages.
• Developed several Tables, Stored Procedures, functions and views to load data from/into the SQL server
• Developed various Charts and Graphs like bar charts, line charts, pie charts etc
• Discussed business requirements and mapped business needs. Used Query for ad hoc Reports and Users design Custom Queries. Analyzed reports and fixed bugs in stored procedures.
• Interacted with end users to gather requirements to create technical and user’s documentations.

Environment: SQL Server Management Studio, SSIS, Business Intelligence Development Studio, PLSQL Developer, Teradata SQL Assistant, SQL, T-SQL, PL/SQL.

Confidential

SQL Developer

Responsibilities:

• Involved in data analysis and development.
• Involved in the design and development of mappings from legacy system to target data base.
• Created complexSQLQueries, Stored Procedures and Functions to support efficient data storage and manipulation.
• Modified current database by adding tables and relationships to support online system.
• Created and managed complex batch jobs.
• Defined Constraints, Rules and Defaults.
• Created Views as required by front enddeveloperfor easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Reorganization of data and index pages and Fragmentation of index usingSQL.
• Performed daily tasks including backup and restore by usingSQLServer 2005 tools likeSQLServer Management Studio,SQLServer Profiler and Database Engine Tuning Advisor.
• Implemented the newSQLServer 2008 concepts like Data partitioning, Snap shot isolation, Database mirroring, database snapshot, DDL triggers.
• Extensively worked on performance issues like update statistics, Auto Stats.

Environment: SQL, T-SQL, PL/SQL, Unix/Linux, SQL Server Management Studio, Microsoft Visual Studio, PLSQL Developer, Teradata SQL Assistant, Erwin

Confidential

Jr. SQL Developer

Responsibilities:

• Interpret data and analyze results using statistical techniques and provided ongoing reports.
• Gathered requirements, designed and developed solution using various data sources available.
• Performance tuning ofStored ProceduresandT-SQL Queries.
• Createdindexeson selective columns to speed up queries and analyses in SSMS.
• UsedExecution Plan,SQL Server Profilerto trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Added additional constraints by identifying fallible situations to make the algorithm robust and prepared documentation for the algorithm implementation.
• Helped to build report interfaces, data feeds, validating and reporting the results, which make the complex decisions easy and clear.
• Developed several Tables, Stored Procedures, functions and views to load data from the SQL server.
• Extensively used PL/SQL Procedures/Functions to build business rules.
• Performed daily data queries and prepared reports on the weekly, monthly, and quarterly basis.
• Used advanced Excel functions to generate spreadsheets and pivot tables.
• Extensively involved in data modeling and Production Support.

Environment: MySQL, SSMS, Teradata SQL Assistant, Aginity Netezza workbench.