PROFESSIONAL SUMMARY:

• Over 7 years of Comprehensive Experience in Database Management and providing Business Intelligence Solutions using Data warehousing Technologies.
• Extensive experience in Design, Development, Implementation of Database systems using MSSQL for OLTP and OLAP systems.
• Developed SSIS Packages to populate Data Mart from various types of sources files (EXCEL, Access, Flat files, CSVs, XML, OLEDB Sources) and Experience in creating Ad - hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Very good knowledge in designing database objects like Tables, Views, Constraints, Indexes and defaults.
• Involved in Security Administration, managing schemas (2008/2005), creating Credentials, creation of users, configuring permissions and assigning roles to users.
• Dexterously rendered proactive technical support in troubleshooting issues, identifying the root causes and to prevent recurrence.
• Proficient in data processing streaming/batch and data analysis using Big Data technologies like MapReduce, Hive, Impala, Spark, Pig & Linux scripting
• Sqoop and Flume for data migration/data ingestion.

TECHNICAL SKILLS:

RDBM/Databases: MS SQL Server 2005/2008/2008 R2/2012, Oracle9i/10/11g, MySQL, MS Access 2003, Visual Source Safe 2005, Teradata

BI Tools: Talend, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analytical Services, Data Transformation Services (DTS), Visual Studio, BIDS.

Programming Languages: Confidential -SQL, PL/SQL, Dynamic SQL, MDX, Bash Scripting, Python, Pig Latin, HQL4

IDE/Database Utilities: Putty, Amazon Workspaces, Talend Studio, SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, Crystal Reports 9.0, Visual Studio Team Foundation Server (TFS).

Data Modeling: MS Visio, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-normalization Techniques, MS- Access.

Hadoop Eco System: HDFS, MapReduce, Hive, Pig, Sqoop, Flume, Oozie, Impala.

Amazon Web Services: S3, EC2.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Big Data & SQL BI Developer

Responsibilities:

• Involved in designing of the databases and altering schemas of the existing data bases.
• Created new schema objects like stored procedure, Functions, Views and did the performance tuning on the existing Objects.
• Created the Dynamic ETL’s to Load different Source systems like Excel, Flat file, and Oracle databases using SSIS 2015.
• Created Power BI reports and Dashboards.
• Created, maintained and supported Power BI reports with various visualizations such as Bar Charts, Pie Charts and Tree maps.
• (SSRS), developed various enterprise reports, drill thru reports, drill down reports and multi-valued parameter reports.
• Developed a POC to migrate one of our application to Big data eco system.
• Dumped some of our data set which are in sql databases into HDFS.
• Dealt with file formats like XML, CSV, TXT etc.
• Created hive external tables and pointed them to HDFS locations.
• Parsed complex data using hive serde’s.
• Translated the Confidential -sql transformation logic to Hive (HQL), applied the logic to hive tables and loaded final data into the subject areas per requirement.
• Created audit tables in order to track the performance of the application in data lake.
• Optimized the entire work flow and automated the whole jobs using Oozie.

Confidential, HOUSTON TX

SQL BI Developer

Responsibilities:

• Actively participated in supporting and enhancing logical design of the system to in corporate changing business and user requirements.
• Involved in Code Reviewing and Suggesting changes to script.
• Designed & developed ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations
• Deployments of code from test to prod using Red gate Tool.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used Red gate Monitoring Tool and SQL Server Profiler to trace the slow running queries and also the server activity.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor and SQL Queries.
• Resolved issues as per request business request.

Confidential, Beaverton, OR

SQL BI Developer

Responsibilities:

• Involved in supporting more than 70+ internal & external Users for various Reporting Business Units and departments
• Involved in complete lifecycle of the Project right from DEV-> QA->Pre-Prod-> Prod (SDLC)
• Development, Enhancements & Implementation of existing SQL Stored Procedure’s based on new requirements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration
• Involved in writing multiple reports incorporating business logic and user requirement.
• Created reports for daily, weekly, monthly reports for Business Users for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Querying, creating stored procedures and writing complex queries and Confidential -SQL Joins to address various reporting operations and also random data requests.
• Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources
• Involved in writing Complex Queries, heavy stored procedures, Views, Triggers, Functions using Confidential -SQL
• Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.
• Loading the Fact and Dimension tables using SSIS Packages.
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008 and were integrated in the Performance point server.
• Creating and maintaining various subscriptions in the Report Manager for the reports.

Confidential, Houston, TX

SQL BI Developer

Responsibilities:

• Worked with various departments customers in interfacing various systems and processes for Data extractions, ETL, Analytics and reporting needs
• Point of contact for all the Data processes, Data Mappings, Data dictionaries, Data pulls and Reporting solutions.
• Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations.
• Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration
• Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Deployed the generated reports on to the server
• Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Loading the Fact and Dimension tables.
• Querying, creating stored procedures and writing complex queries and Confidential -SQL Joins to address various reporting operations and also random data requests.
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008 and were integrated in the Performance point server.
• Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various in-house users and also for various users
• Creating and maintaining various subscriptions in the Report Manager for the reports.
• Developing products by determining what competitors are doing, risk assessments, ratings assessments, pricing and coverage.
• Involved in User communication for requirement gathering and Change control and code control policies and procedures

Confidential, Chicago, IL

SQL DBA/BI Developer

Responsibilities:

• Participated in Installation of SQL Server and related management tools and BI tools on Windows 2003/2008 across Dev/UT/Prod/DR environments.
• Create and Maintain databases after logical and physical database design.
• Set database Access Privileges for different users and user groups using Active Directories and SQL Server Logins.
• Wrote various kinds of DDL and DML statements for creation of database objects including Tables, Views, Stored Procedures and Indexes.
• Wrote complex Stored Procedures/Functions in Confidential -SQL for various applications which sits on top of the database
• Involved in importing and exporting data from text files, MS Excel and other OLEDB sources into SQL Server using SSIS/DTS and Vice Versa.
• Optimized and Involved in Rewriting and Brainstorming Cost Intensive SP’s.
• Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data from various Databases
• Implemented the Indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
• Involved in Code Reviewing and Suggesting changes to script to meet ANSI SQL standards.
• Involved in Creating Partitions for Huge Tables and Involved in Tuning and Optimizing Confidential -SQL to reduce effect on OLTP System.
• Involved in complete lifecycle of the Project right from DEV-> QA->Pre-Prod-> Prod
• Used various SQL Server Performance tools and commands like Execution Plan, SET STATISTICS IO to read logical reads, DBCC to check inconsistency in DB, SQL Sentry.
• Create Jobs and Monitor job history for maximum availability of data and to ensure consistency of the databases.
• Involved in creating SQL Server Coding Standards Document.
• Used various tools like IDERA, Lite speed and SQL Server Native Tools to Backup and Restore Database.

Confidential, Houston

SQL/SSIS/SSAS/SSRS (BI) Developer

Responsibilities:

• Actively participated in supporting and enhancing logical design of the system to in corporate changing business and user requirements.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Accomplished the task of converting DTS packages from /2008 by using SSIS tasks in SSMS, BIDS and troubleshoot the conversion process
• Involved in database design process and data modeling process using diagrams and Visio.
• Created Joins, Views, Stored Procedures, Functions and Triggers and also scripted Sub Queries using Confidential -SQL involving multiple numbers of tables.
• Studied existing OLTP system(s) and Created Facts, Dimensions and Star Schema representation for the Data Mart.
• Developed SSIS Packages to populate Data Mart from various types of sources files (EXCEL, Access, Flat files, CSVs, OLEDB Sources).
• Handled SSIS packages for Logging, error handling, complex transformations, Deployment and production support.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints
• Created cubes using respective fact and dimension tables, performed processing and deployed the cubes to SQL server analysis services database.
• Involved in adding KPI’s, Calculated Aggregates, Actions and Partitions.
• Created Ad Hoc reports by building models in Report Builder using SSRS 2005/2008 Model Designer and Report Builder
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created parameters (multivalue, hidden, default etc...) for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc. to make them more attractive and understandable.
• Created Pivot Tables and Pivot Charts in MS Excel.
• Experienced in building MDX queries and DMX (Data Mining Expression) queries for Analysis Services & Reporting Services.
• Reporting OLAP cubes built with Microsoft Analysis Services using SharePoint as a front-end tool.