NAREN RAJA PACHAVA

**** ********* ** 615-***-****

#C9, Nashville TN 37211 LinkedIn: in/narenrajapachava ac1udw@r.postjobfree.com

Passionate & skilled IT professional with 5 years of demonstrated expertise in database development, data analysis and data quality testing, specialized in both web based and client server applications. Strong competence in agile and waterfall methodologies. Proficient in employee training, team building and client presentations.

SKILLS

Tools: SQL Developer, PL/SQL Developer, Eclipse IDE, Bugzilla, JIRA, IBM RTC, Visio, Microsoft Office Suite

Test Management Tools: HP Quality Center, HP Application Lifecycle Management, TCS RTS.

Programming: Java, C, HTML, CSS, SQL, PL/SQL, R, Python

Databases: Oracle, SQL Server, My SQL, MS Access

Analytical: SAP BOBI, Rapid Miner, KNIME, SSIS, SSAS, SSRS, SAP BO

Testing Methods: Functional, regression, load, UAT, security, black box, white box, system, integration, production

EXPERIENCE

US Geological Survey, Chesterton, IN Jan 2017 - May 2017

Data Science Intern

•Designed project proposal, work flow, WBS, project scope, project case, SWOT Analysis and BOM documents

•Extracted data from various sources like; CSVs, HOBO files, .txt files etc.

•Modeled data using R Studio and uploaded the data into Oracle DB using SQL Loader

•Modified data in Oracle DB using SQL Queries on SQL Developer tool

•Conducted market research on 3rd party tools for data visualization, building reports

•Analyzed data by visualizing the statistical values derived on yearly, monthly, weekly & daily format

•Performed statistical analysis on the data and observed results using SQL Developer

•Documented processes, lessons learned using MS Visio and other Office tools

•Trained new team on data analysis & SQL

•Single handedly handled the entire project from planning to modelling and analysis

Tata Consultancy Services, Hyderabad, India May 2013 - Dec 2015

SQL BI Developer

•As a key member of BI team, delivered the best results to the development needs, accomplished successful outcomes by working with SSIS, SSAS and SSRS.

•Supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members.

•Trained/guided new or junior developers in certain development areas helped them to understand better the project process.

•Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.

•Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the data warehouse.

•Created the optimal logics to load the data that business rules were based on flat file names or ragged hierarchy.

•Regularly worked/used TFS and did Incremental Load using for each Loop, Sequence containers, Script Task, Conditional split, Data Conversation, Derived Column, Lookup, Merge/Merge Join, Union all and so on in Visual Studio 2008 R2/2012.

•Identify and resolve problems encountered during both development and release of the SSIS code.

•Debugging and troubleshooting the technical issues while implementing the applications.

•Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

•Created packages in SSIS with error handling and worked with different methods of logging in SSIS

•Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.

•Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

•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 complex transformations using SSIS/DTS packages.

•Worked on QNXT claims and Conversion of Interface Programs from Legacy to QNXT.

•Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and Updating and maintaining Visual Source Safe.

•Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.

•Responsible for data analysis, loading data from Data feed to Data Warehouse tables.

•Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

•Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

•Created views to display required information on user interface, and triggers to validate consistent data entry into the database.

•Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.

•Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).

Syner Matrix Technologies Private Ltd., Hyderabad, India Sep 2011 - Apr 2013 SQL Developer

•Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.

•Created packages using the various control flow task such as data flow task, execute SQL task, Execute package task, File System task.

•Actively participated in gathering of User Requirement and System Specification

•Developed database objects like tables, views, stored procedures in SQL Server 2008

•Created Partition Tables based upon Partition Functions and Partition Schemas

•Involved in Performance Tuning of the Stored Procedures, User Defined Functions and long running queries.

•Created reports based on the format specified in the design document

•Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer

•Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.

•Involved in development and modification of existing Financial Reports and Marketing Reports, which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.

•Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS

•Created reports using SQL Server reporting services SSRS, which is then exported as PDF. Reports variables are passed from ASP.NET web pages.

•Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS

•Created reports using SQL Server reporting services (SSRS), which is then exported as PDF. Reports variables are passed from ASP.NET web pages.

•Involved in creating Dataset in the MS reporting services (SSRS) for calling the stored procedures and passed the parameters to the dataset.

•Developed reports using excel power views and dashboards pointing to SSAS cube source and deployed to MS SharePoint.

•Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks

•Involved in Unit Testing, Integration and deployment in Production and Staging Servers.

EDUCATION

Valparaiso University, Valparaiso, IN

Master of Science in Information Technology Management Jan 2016 - May 2017

•Project Management Project - Managed 5 teams through initiation, planning, monitoring and supporting execution

•MLK Day 17: Led 20 volunteers as a part of steering committee member to communicate message into community

•Published thesis paper on “What is necessary to be a successful Entrepreneur?”

Avanthi Institute of Engineering & Technology, Visakhapatnam, India

Bachelor of Technology in Electronics and Communications Engineering Aug 2007 - May 2011

•Blitz – Organizer, the only person selected among Freshmen and Sophomore classes

•Class Representative for 3.5 out of 4 years and led colleagues in events, projects and other activities

Contact this candidate