SUMMARY

• Aspiring SQL, ETL, Reporting Designer and Developer with 7.2 years of work experience through the life cycle phases like requirement gathering, designing, coding and testing covering most of the Databases, BI tools and practices.
• 6+ years of experience as a Database and Data Warehouse developer in databases like Sybase 15, Greenplum Postgress SQL, Oracle 9i, 10g, and SQL Server 2008/12/14/16 .
• 6+ years of experience in using ETL tools like Informatica PowerCenter 9.5, SSIS 2008/12/14/16 , Clover ETL.
• 6+ years of experience in Reporting tools Cognos 10, SSRS 2008/12/14/16 , and Crystal Reports 14.1.
• 6+ years of experience in coding and analysis in SQL, T - SQL, PL/SQL queries with proficient enough to code debug and analyze complex SQL queries.
• Expertized in creating DDL, DML, Inner join, Left join, Right join and full join using T-SQL.
• Excellent understanding of full Software Development Life Cycle (SDLC) in Agile and Waterfall SDLC process environment.
• Extensively worked with RDBMS Modeling and Dimension Modeling using Star Schema as well as Snowflake Schema.
• Expertized in designing Conceptual, Logical and Physical model as part of Database and Data warehouse design.
• Extensively worked in developing ETL Data Flow Transformations such as Aggregate, Lookup, Merge Join, Multicast, and Conditional Split using Informatica.
• Proficient in performing various SSIS data transformation task such as Aggregate Functions, Merge Join, Conditional Spilt, Data Conversion, Derived Column, Event Handlers, and Error Handlers etc.
• Extensively worked in different studios in Cognos 10 Reporting tool (Frame Work Manager, Report Studio, Query Studio, and Analysis Studio).
• Extensively worked on modeling the data mart using Frame Work Manager (Cognos), Data Source Designer (SSAS) for Report development and Data analysis.
• Experience in report writing using SSRS 2008/12/14/16 , creating reports like Tabular, Matrix, Drill Down, and Drill Through.
• Experience in developing reports and dashboard using Power BI Desktop and Tableau 10 tools.
• Experience in extracting data from different heterogeneous sources, transforming and loading process using Clover ETL 8, MSBI SSIS 2008/2014/2016 and Informatica Power Center 9.5.
• Experience in working with conversion projects related to Database conversion, ETL conversion and Reports conversion from one platform to another platform.
• Proficient in design and development of J2EE applications using Core Java, Collections, JDBC, Servlets, JSP, EJB, JSON, XML.
• Strong Business knowledge in Finance, Banking, Brokerage, Healthcare Insurance Operations.
• Good understanding of UNIX, Shell scripting, SAP Business Objects, NOSQL, Postgress SQL and MongoDB databases.
• Expertized in working with application development in sprints using AGILE methodologies and conducted SCRUM meetings.
• Proficient in designing and developing of Forward, Revers Engineering, Technical workflow project documentation.
• Participated and presented in the IT Corporate Training group (HYD-SIG) in and around Hyderabad.

TECHNICAL SKILLS

Languages/Technologies: SQL, PL/SQL, T/SQL, Postgress SQL, N-SQL, VB scripting, UNIX scripting, Python.

Frontend Technologies: Core Java, JDBC, EJB, Servlets, Struts, ASP .Net, HTML, XML.

Reporting Tools: Cognos 10.x, Qlikview, Tableau 6, Power BI 2013, SSRS 2008/12/14/16 , Jasper Reports, Crystal Reports, SAP BO

ETL tools: Informatica PowerCenter 9.x, 8.x, Ab Initio, Jasper ETL, Clover ETL, SSIS 2008/12/14.

Database: Oracle 10g, Sybase 15.x, Greenplum, SQL Server 2008/2012, NOSQL, MongoDB.

Development Tools/IDE: Eclipse Galileo/Gynamite, MyEclipse10.6, Visual Studio 2010, Putty, Toad, Cognos 10 Studios, Informatica PowerCenter Components 9, PL/SQL Developer, SQL Profiler, MS Office 2008/12/14/16 .

Build & Deploy Tools: Ant build, SVN, AUTOSYS job Scheduler, UC4, Tidal, Freemind Mapping tool, Remedy, JIRA, ITSM.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr SQL BI Developer

Responsibilities:

• Worked as a SQL developer to develop and enhance Stored Procedures for new report development at different LOB levels.
• Develop T-SQL Queries, Stored Procedures, functions and Error Handling related to Sybase Database. Build/modify stored procedures based on business requirements.
• Worked with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) for high performance Data Integration, Data Migration and report generation.
• Scheduled the developed SQL scripts, stored procedures, functions in the scheduler to kick start the further business process on daily basis.
• Experience in administering SSIS packages such as Scheduling package execution, backing up and restoring packages, monitoring integration services performance and activity, and implementing security considerations for SSIS Packages.
• Analyzed the data in SSIS packages that feeds to the target table and then used by reporting components in SSRS reports.
• Experience in creating Report Models for building Ad hoc reports using SSRS based on the exiting Crystal report business functionality and layouts.
• Gained Domain knowledge on Healthcare system regarding how Claims related to Medicare and Medicare plan been processed and reported to the end user in different reports.
• Working on conversion process of existing Crystal reports to SSRS reporting.
• Developed scheduling mechanism on Tidal to run the existing Crystal and newly enhanced SSRS reports.
• Enhance existing crystal and web intelligence reports in SAP BO by modifying Universe logic to achieve the business needs.
• Actively involved in change management process to deploy database objects to QA/UAT/Production servers.
• Support QA and release management procedures and general system maintenance through HP QC and ITSM.

Environment: Sybase 15, MS SQL Server 2012, SAP Crystal Report 10, SAP BO (BI Launch Pad, SAP CMC, SAP TMC), ASE ISQL 15, Tidal 6.x, UNIX, HP QC, ITSM,SQL, T-SQL, PL/SQL.

Confidential

Sr SQL BI Developer (SQL/ETL/Reporting)

Responsibilities:

• Worked as a database developer for MS SQL Server 2008/2012 to develop T-SQL, stored procedures and views, functions and created ERD for few modules.
• Extracted data from Greenplum, Sybase and migrated into SQL Server stage table using SSIS.
• Designed and Developed Complex SSIS packages for auditing Interfaces using SQL SERVER 2012 Integration Services.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS for workday feed to update profile table.
• Created data flow tasks in SSIS packages to load the required target table with data from different file sources using transformation to modify the source data into required business data.
• Created Database objects like tables, functions, stored procedures and scripts in SQL Server to accommodate the function logic same as source system (Sybase, Greenplum and flat files).
• Handled migration of data from Sybase, Greenplum existing source database to MS SQL 2012 Database.
• Developed migration flows in SSIS packages to convert the data from Sybase, Greenplum to SQL Server database objects.
• Developed pre and post validation SQL scripts to validate the conversion data load and data migration process.
• Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail using SSRS 2012 reporting services.
• Created different dashboards with interactive data for the Monthly billing system using SSRS 2012 service.
• Used Power BI as the POC for creating different dashboards on top of SSAS cubes internal to the same project.
• Worked with business team to enhance the existing reports to better fit the new requirements in the existing logic.
• Creating a staging area in SQL Server to load the source data using SSIS using different Transformation logics to source data.
• Validated the scripts, data flow tasks, functions, procedures and source data as part of DEV test run.
• Monitored the data and post production run for the fix, new enhancements made to the existing reports and code.
• Used UNIX basic commands to work with flat file in different regions and to modify he file data during test runs.

Environment: SQL Server 2008/2012, MSBI 2008/2012 (SSIS, SSRS), Greenplum Pg-SQL, Sybase 15, MS Office 2010, SQL Loader, Power BI Desktop 2015, UNIX.

Confidential, Houston, TX

Miniature Product Sales

Responsibilities:

• Analyzed the requirements to design Conceptual, Logical and Physical model for the new Data warehouse storage.
• Analyzed the requirements and identified the FACT and DIMENSION tables of the Miniature Product Sales project.
• Designed the data flow process on how and when to load the data into FACTS and DIMENSIONS.
• Created different Data Flow documentation which includes how data is loaded into each and every Dimensions and dependent upstream load to complete prior to it.
• Designed the ER representation of the FACTS and DIMENSIONS using Visio to show the Logical design of the data warehouse.
• Created Snow Flak schema and loaded the dimensions and facts with sample test data provided using SSIS 2014.
• Created SSIS data flow task to load the dimensions based on the data load dependencies in SSIS packages with in a project.
• Created different mapping in the Data Flow Task and created the load sessions in Event Flow Tasks.
• Used different transformation and Expressions internal to the Data flow task in the SSIS package.
• Worked with different sources like Excel, CSV, Text, Table extracts and database tables to import the data into the new data warehouse structure.
• Involved in SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server.
• Created reports in SSRS for different extract and sales representations. Created notifications of reports once the report gets triggered.
• Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail using SSRS reporting services.
• Created a data CUBE for the summarization of the gross sales based on the historical data been loaded using SSAS 2014.

Environment: SQL Server 2014 Microsoft Business Intelligence Tools (SSIS, SSAS, SSRS), Oracle 10 g, MS Office 2010, UNIX, Putty, VISIO 2010.

Confidential

Senior Member Technical

Responsibilities:

• Worked as a Business Intelligence designer and developer with hands on implementation on RDBMS, Data Warehouse, ETL and Reporting tools.
• Created and deployed Data base object s using DDL, DML and DCL to support the new structure in T-SQL coding standards.
• Developed Stored Procedures, SQL scripts (pre and post) to reach the Business Requirement.
• Designed and created documentation for Data load process from different sources to target using Erwin modeling tool.
• Created Mapping documents to load the data from source to target which includes Transformation logic and conditions to be implemented in both SSIS and Informatica.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS and Informatica
• Created ETL Mappings and Workflows using Data Flow Task, Work Flow Manager using SSIS and Informatica.
• Created different work flows and sessions in Informatica to load the data from file source to the Dimension and Fact in Data warehouse.
• Created Mapping Events Handlers and Event Parameters for the ETL Packages in Event Handler Task, Session Manager using SSIS and Informatica.
• Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using Cognos and SSRS.
• Scheduling and Monitoring monthly jobs automations proceedings using SSIS packages and Postgress SQL Script.
• Developed SQL scripts as part of scheduling the data integration process using UC4 job scheduler.
• Analyzed the work flow from front-end to the data. As part of analysis worked with UI team on enhancements to be bade on front-end code to accommodate the changes.
• Worked with Business Team to stabilize things, suggested ideas and implemented many for better performance of the process/project.
• Worked with QA Team in testing the SQL scripts and Informatica/SSIS work flows in different environment and regions.
• Been part of Review Team of validating the development with the requirements.
• Created pre and post validation SQL scripts and procedures to validate the load run based on the business logic.
• Developed and maintained detailed level source to target mapping documentation for the ETL loads and Extracts.

Environment: SQL Server 2008 Microsoft Business Intelligence Tools (SSIS, SSAS, SSRS), Python, Informatica PowerCenter 9.5, Cognos 10, Visual Studio 2010, Sybase, Eclipse, Core Java, Oracle, Greenplum, Erwin, JBOSS, UC4 9.