SUMMARY

• IT professional with more than 10 years of experience in Information Technology with emphasis on data analysis, report development, project management and database development with SQL server, Teradata, Hadoop, Big Data, Oracle and DB2.
• Strong working experience in the Data Analysis, Data Mining, Data Quality, Design, Development, Implementation for various Data Warehouse and business applications.
• Understanding of Big Data / Hadoop Architecture including HDFS, Hive, Spark, PIG, Sqoop, HBase.
• Highly skilled in designing and developing reports in various reporting environment like SSRS, Logi Analytics, Tableau, Crystal reports, SAP Business object, WebI reports, Xcelsius Dashboards and Universe Design for major clients in industries
• Experience in writing Complex T - SQL Queries, user defined functions, views, Dynamic Queries Sub-queries, stored procedures, Complex Joins.
• Experience in designing Batch Jobs and automating task by utilizing T-SQL and SSIS packages in SQL Server 2016.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Ad-hoc reports, Sub reports using Global Variables, Expressions, Functions, defining data sources for the reports.
• Experienced back end developer for financial, health care, insurance and Telecommunication industries.
• Worked on the complete SDLC IT projects from feasibility analysis, requirement gathering, integration testing, UAT, deployment, maintenance, support and training. Involved in all phases of BI SDLC in Agile/Scrum/Iterative Methodology.
• Excellent ability to perform independent preliminary analysis of user requirements, develop effective solutions that satisfy requirements.
• Led several IT projects, including supervising workload, scheduling, working with clients and end users.
• Used Microsoft team foundation Suite (TFS) for version control.
• Quick learner, enthusiastic and project oriented team player with great communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

Programming Languages: SQL, T- SQL, PL\SQL, HIVE, SQOOP, People Code, Java Script, HTML, COBOL, JCL, VB script, Python

Data Base: SQL 2016, Teradata, Hadoop (HDFS) Access 2007, DB2, Oracle8i

Operating System: Windows 2000/XP/7, UNIX

Reporting Tools: Crystal Report XI, SAP BOE XI 3.1, SSRS, Logi Analytics 12.0, Tableau, Oracle Hyperion, PS/Query, nVision, SQR.

Tools: SQL Server Management studio, SQL Server Business Intelligence Development Studio (BIDS), SSIS, TFS, Business Object 3.1, IBM Optim development studio 2.2.1, Erwin Data Modeler, AQT, Rapid SQL 8.1.1, Secure CRT, Secure FX, Remedy, Control M, Mainframes sessions (Super session, TSO). Visio, HP Quality Center 10.0

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr SQL Developer

Responsibilities:

• Led Several Business Intelligence IT Projects.
• Mentored and trained Junior developers in team.
• Involved in designing of the databases and altering schemas of the existing data bases.
• Imported data from structured data source into HDFS(Hadoop) using Sqoop incremental imports.
• Created Hive tables, partitioned and implemented incremental imports to perform ad-hoc queries on structured data.
• Executed Hive queries on tables and stored in Hive to perform data analysis to meet the business requirements.
• Created new schema objects like stored procedure, Functions, Views and did the performancetuning on the existing Objects.
• Designed and developed ETL jobs to Load data from different source systems like Excel, Flat file, and databases using SSIS 2012.
• Implemented the Error logs, log tables and Event handlers for the existing packages.
• Worked with installation, configuration and deployment of SQL Server Reporting Services(SSRS), developed various enterprise reports, drill thru reports, drill down reports and multi-valued parameter reports.
• Redesigning existing letter generation process to automatically send letter out to the clients on daily basis as they enroll in new program.
• Redesigned the process to automatically generate pharmacy benefit cards for patients enrolling in new programs.
• Redesigning existing crystal reports into SSRS reports.
• Worked on Migration effort for migrating data from SQL Server 2005 to 2012.
• Involved in data validation activities after migration is complete.
• Redesign SQL Server jobs to fit in new database schema for SQL Server 2012.
• Setting up jobs to run on SQL server 2012 on Daily\Monthly\Weekly basis.
• Developing new reports on ad-hoc basis.
• Worked on complex stored procedures (T-SQL) to utilize them in Logi, SSRS reports and SQL server jobs.
• Supported legacy Client Tracking System for bug fixing and maintenance work.
• Experience working on Logi Analytics BI tool for reporting.
• Designed, Developed and scheduled Logi reports per business needs.
• Actively maintained and monitored existing Logi reports, helped team members in designing and development of new reports.
• Automating several IT tasks to minimize manual work.

Confidential, Omaha, NE

Software Analyst

Responsibilities:

• Worked on several BOE reports for maintenance and enhancement purpose.
• Developed complex BOE reports by fetching data from multiple universes and further applying constraints.
• Developed complex crystal reports with ability to import them in client specified formats.
• Developed complex stored procedure in SQL Server 2012 utilizing self joins and temp tables to fulfil reporting needs.
• Created SSIS packages to load data in flat files and further transfer files from one location to the other using FTP task for client deliverables.
• Developed stored procedures to perform data manipulations for sql server batch jobs.
• Data analysis to identify data mismatch.
• Worked on Dash boards to in corporate multiple reports in to one.
• Provided timely support to data information planning effort.
• Experienced working with end-users, performing requirements analysis, and writing documentation.
• Set up automation for BOE as well as crystal report based on client requirement.
• Monitored BOE jobs thru CMC on daily basis those have been automated to run at scheduled time. Troubleshooting jobs in case of failure.

Confidential, Omaha, NE

Business Intelligence Developer

Responsibilities:

• Worked on various crystal reports development and maintenance project and published them on info view.
• Automated crystal reports to send out to multiple different recipients like report bursting.
• Designed and developed existing Hyperion reports in Crystal Reports Developer XI.
• Constantly worked with Business users to provide them with the data in form of drill down crystal reports and excel sheets for analysis.
• Created complex stored procedures to generate reports using SSRS.
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Extensive experience in integrating data using SSIS and further generating reports using SQL Server Reporting Services (SSRS) from relational databases.
• Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
• Created SSIS packages to load data from flat file to the database using Lookup, conditional split, aggregate transformations.
• Worked with the IT team to bring in the data required into Business Objects Universe so as to make available for super users to create Adhoc reports.
• Replicated/Migrated reports created in internal reporting tool like Hyperion to Business Objects
• Worked on cross-tab and master detail reports. Also represented the same as line charts/ bar charts / pie charts of the same.
• Extensively used Designer to design various universes for different business groups.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Setup extracts for business user using webi so that they can plug new prompt values and refresh it whenever required for their analysis purpose.
• Created web intelligence document for business users to drag and drop objects as per their reporting needs.
• Analyzed large amount of data to identify redundancy and inconsistency.
• Worked on MS Access queries, macros, forms and modules.

Confidential, Omaha, NE

Contractor

Responsibilities:

• Worked on Confidential Medical Supplement project.
• Developed several reports in Hyperion and MS Access.
• Created ad-hoc reports using SQL server 2008 Reporting Services (SSRS).
• Performed ETL activities using SSIS and Informatica.
• Developed ETL mappings, transformations using Informatica Power Center 8.6.1
• Developed data Mappings between source systems and target system using Mapping Designer.
• Extracted data from HP Quality Center tool for analysis purpose.
• Scheduled reports are per business need for automation purpose.
• Worked on DB2 stored procedures for writing complex sql queries and further utilizing them in crystal reports development.
• Actively participated in design, development and implementation of BOE Universe.
• Created several views in process of designing universe.
• Developed Line, pie or bar charts using web intelligence document.
• Proactively interacted with other IT teams to manage work and in corporate business needs.

Confidential

Contractor

Responsibilities:

• Gathered user requirement for upgrades and done fit gap analysis.
• Analysis of customized code and compare report during upgrade process.
• Liaison between the client team and the technical team to help them understand business requirements.
• Performed data conversion activities using SQL and analyzed compare reports.
• Developed crystal reports with dynamic parameter values by creating LOV.
• Participated in design and development of BOE Universe.
• Created ETL jobs using Data Stage from various sources also performed data conversion activities.
• Developed and maintained nVision reports.
• Report generation using query tools.
• System testing and UAT for bundles and patches.
• Actively participated in meetings with end users during testing phase after implementation of patches.

Confidential

Software Engineer

Responsibilities:

• Performed complex data analysis across all foundation tables for AP\PO modules.
• Provided solution for all enhancements in various PeopleSoft modules.
• Developed customizations in People Tools as necessary (Views, Indexes, App Engine, etc.)
• Designed and developed Crystal reports to analyze purchase orders and billing details.
• Developed SQR reports and scheduled them to dispatch PO.
• Designed and develop workflow for various processes.
• Analyzed, customized and enhanced various SQR reports and Application.
• Extracted data using PS Query for analysis purpose.
• Researched and documented all functional issues, resolutions, setup steps and data mapping.
• Provided day-to-day support for batch jobs.
• Identified test scenarios, created test cases from business requirements using HP Quality Center.
• Interaction with Business lead for functionality clarification and status reporting.

Confidential

Peoplesoft Developer

Responsibilities:

• Played vital role in Requirement clarifications and Design documentation.
• Designed and Developed crystal report for management to analyze contract renewals and PO.
• Hands on experience writing complex SQL queries to retrieve data from database using tool like AQT and Rapid SQL.
• Involved in Support and Customization of Components, Pages and Records.
• Developed customized workflow for voucher approval.
• Developed SQR for generating report for all the pending vouchers in work list.
• Performed planning and data conversion activities.
• Responsible for meeting the quality standards and the planned schedule of deliverables.
• Responsible for carrying out the project plan, allocation of work to the resources, day-to-day interaction and status reporting to business.
• Providing Functional inputs to Offshore & Onsite team.