SUMMARY

• 14+ years of experience in IT and involved in all the phases of Software Development Life Cycle.
• Defining tables and views and maintaining data among different databases like IBM DB2, SQL server, Oracle.
• Designing ETL jobs for loading data using IBM DataStage. Handled data in XML structure, Shred the data from XML and loads it into Data Warehouse.
• Handling a database of 8TB with 3000 tables and 18000 jobs for loading data into it, scheduling jobs both in AIX servers and data stage director.
• Database designing and dimensional data modelling
• Handling Data warehouse as an admin, granting access to tables upon service request and revoking unwanted users and roles.
• Handling Datastage admin role, creating Datastage projects, set up environment variables, grant access to projects, troubleshooting user issues.
• Writing UNIX script in AIX server for ETL activities, defining environments, set parameters, writing export and load queries, giving correct permissions to users and group.
• Developed around 5000 jobs in IBM data stage, especially parsing data from XML to relational tables. Set up the parameters and table definitions. Handled different stages in DataStage, fixing the job errors, scheduling it on daily or weekly basis, monitoring the jobs daily.
• Database health checkup and performance monitoring. Resolving performance issues.
• Worked on Data server manager and Workload manager for database performance improvement.
• Delivered data quality projects within the project time frame.
• Handling customer complaints respond to it and solve as soon as possible.
• Handling database and datastage access requests and incidents through ITSM 2.0.
• Writing SQLQueries and involved in programming of stored procedures, triggers, cursors, functions to implement the business logic.
• Used SQL Server profiler and database tuning advisor for performance tuning.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Developed Test Cases bases on Requirement Specifications and Design Documents.
• Responsible for creating database objects like table, Views, Store Procedure, and Triggers.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Take part in datastge software installation and up gradation.
• Trained new team members with presentation.
• Supervising team members, assigning work to them, giving them necessary guidelines and finish the task on time.

TECHNICAL SKILLS

ETL Tool: IBM DataStage 7.X, 8.X, 11.X, SSIS, Informatica

Databases: IBM DB2, Oracle 10g, SQL server, Mainframe

Programming: T - SQL, PL SQL, DB2 SQL, C, UNIX scripting

Operating Systems: UNIX, IBM AIX 6.1/7.1, WINDOWS NT, XP,7,10

Business Intelligence Reporting tools: SSRS, COGNOS

Data Warehousing: Data Marts, Dimensional modeling, Star Schema. Snowflake Schema

Data Modeling Tools: Erwin 7.0, Microsoft Visio,IBM data studio, MS Visual Studio, Data base design Manual testing, quality assurance

PROFESSIONAL EXPERIENCE

Data warehouse ETL DEVELOPER

Confidential, ALBANY, NY

Responsibilities:

• Working for NYS DTF as IT Specialist 3, Developing ETL jobs using IBM data stage and UNIX scripts for extracting and loading Tax data into data warehouse.
• Lead different big projects like Personal Income Tax, CORP tax, Sale tax. Created DB2 database design, tables, views and developed ETL jobs for extracting and loading the data into data warehouse.
• Writing SQL queries and XML queries for exporting the data from different databases and transform as per the requirement and load it into our data warehouse for Tax users.
• Handling the admin role for Data warehouse server and IBM DataStage ETL tool.
• Monitoring health checkup for database and resolves performance issue.
• Manage the successful delivery of development projects across the full application lifecycle
• Mentor junior developers on the best practices for developing ETL jobs utilizing Data stage and UNIX scripts
• Handling the customer complaints and security requests via ITSM and resolving the issues.
• Maintaining around 3000 tables and 18000 ETL jobs on daily basis.
• Working as a Datasatge lead and supervise employees on their tasks.

Environment: DataStage 8.5,11.5/11.7, Infosphere quality stage Director, Infosphere Admin Client, Infosphere Admin console, IBM DB2, AQT, IBM data studio, IBM Dataserver Manager, Mainframe DB2, SQL server, AIX, UNIX, Crontab, XML files, Notepad ++, Winscp

Datastage developer

Confidential, INDIANAPOLIS, IN

Responsibilities:

• Worked for Confidential project.
• Extensively worked on Data Extraction from different source databases, Transforms, Loading and Analysis.
• Worked with XML files coming from different databases.
• Extensively used Sequential files, XML input stage, Sort, Funnel, remove duplicates, Merge, Aggregator and created datasets.
• Used quality stage director and its run-time engine to schedule running the solution, testing, and debugging its components, and monitoring the results.
• Provided support for QA and Production Environments
• Created/modified configuration files to balance the load on multiple nodes
• Performed tuning on database queries, ETL mappings and end-user queries
• Extensively used Web services transformer stage to get response from REST calls.
• Tuned Data stage transformations and jobs for Performance Enhancement.

Environment: DataStage 7.X, 8.5, IBM DB2. Infosphere quality stage Director, Mainframe DB2, SQL server, UNIX, Oracle 11g, XML files

Network Engineer

Confidential

Responsibilities:

• Worked for Confidential as a network Engineer.
• Handled 200 cell sites and a BSC with 2G and 3G network, its addition and maintenance.
• Making the network availability 99.99% by giving 24*7 support.
• Fast retrieval of cell site in case of network outages.
• Network upgradation and cell site addition
• Cell site optimization with RF team and handling drive test.
• Clearing BSS and transmission alarms all over the network.
• Handling customer complaints and resolve their network issues.
• Managing the team for completing the cell site installation on time.

SQL SERVER DEVELOPER

Confidential

Responsibilities:

• Works within IT team to follow the full life cycle development process working with development and technical operations.
• Analyzed relationships of Flat Files and to extract the analyzed systems, met with end users and business units to define the requirements.
• Developed data Mappings between source systems and warehouse components.
• Database migration from SQL server 2005 to SQL server 2008.
• Created SSIS packages to load the data into data warehouse.
• Used SSRS to create different reports for the customer (Airtel).
• Work with other team members in establishing and sharing design and development techniques of the ETL process
• Communicate effectively with the other external IT development teams and the local development manager
• Responsible for tuning SQL queries using SQL profiler and adding Indexes to the table.
• Creating test plans and performing different types of testing.

Environment: SQL server 2005,2008, SSIS, SSRS, Oracle database