SUMMARY

• 5+ years of software development experience in the areas requirement gathering, requirement analysis, configuration management, coding, testing, deployment and production support.
• Excellent skills in Analysis, Design Jobs, Planning, Performance Tuning, Implementation and support.
• Customer service focused Technical Support Specialist with 3+ year’s career experience in help desk environments.
• Highly adept in systems analysis diagnostics, troubleshooting and conflict resolution. Exhibits excellent organizational and problem - solving skills. Works well in team environments and displays strong work ethic.
• Troubleshoot, resolve and document user help requests for desktop, laptop, mobile, network and peripheral problems.
• Consistently praised for communicating effectively with both technical and nontechnical users. Known for excellent problem-solving skills and patience in dealing with frustrated users.
• Closed 95% of trouble tickets on the first call without escalation.
• Commended for quickly resolving complex issues including system crashes, network slowdowns, connectivity problems, security breaches, virus infections and more.
• Achieved a user satisfaction rating of 4.9/5.0 (14% higher than average); consistently logged and monitored ticket status to ensure fast, quality resolution of every issue.
• Set up secure WiFi, LAN and VoIP networks at remote locations, leading client/server configuration and performance-tuning of crucial infrastructure to ensure seamless business operations.
• Over 3+yearsof Work Experience inData Integration and migration for Data Warehouses including IBM Info Sphere Datastage(Ver. 9.2.1/8.7/8.5/8.0.1/7. x) Server Edition, Enterprise Edition (Manager, Designer, Director, Administrator, and Parallel Extender).
• Extensively Worked on JobSequencesto control the flow of job execution using various activities likeJob Activity, Email Notification,Sequencer,Routine activityandExec Command.
• Experience in Analysis, Design, Development and Implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP).
• Developedefficient mappingsfor data extraction/transformation/loading (ETL) from different sources to a target data warehouse.
• Experience on theData Modeling phases conceptual, logical, physicalwarehouse databases.
• Experience inPipelineandPartitioning Concept.
• Strong experience in Data Warehouse Development Life Cycle and design of Data Marts with Star Schemas, Snow Flake Schemas and Integrated Schemas.
• Used theDatastageDesigner to develop processes forExtracting,Transforming, and Loadingdata.
• Worked extensively with different database stages ofDatastagelikeOracle Enterprise, Dynamic RDBMS, Stored Procedure, OCI, and ODBC.
• Worked extensively with different file stages ofDatastagelikeSequential, Dataset, File set, Lookup File set.
• Worked extensively with different processing stages ofDatastagelikeFilter, Sort, Aggregator, Copy, Transformer, Funnel, Join, Look Up, Merge, Pivot, Modify, Switch, Change Capture, Surrogate Key Generator, and Remove Duplicates.
• Worked extensively with different development/debug stages ofDatastagelikeHead, Tail, Row Generator, Column Generator, and Peek.
• Worked withLocal Containers,Shared ContainersandJob Sequences.
• Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension (SCD), Change Data Capture (CDC).

TECHNICAL SKILLS

Operating Systems: Windows NT / 2000 / XP Pro / Vista,Win7 / 8 / 8.1 / 10,Windows Server / 2008, Linux - openSUSE, Ubuntu, Mac OS.

Hardware: Hardware:PCs, Laptops, Telephony Systems, Printers, Routers, Modems

Software: MS Office 365 (Word, Excel, Outlook, PowerPoint, Access); Microsoft Outlook ; VMware applications; Microsoft Dynamics 365 ; SharePoint ; Visual Studio ; Microsoft Visio ; Skype for Business ; Bomgar secure remote access ; anti-virus programs

ETL Packages: IBM Info Sphere DataStage (Ver. 9.2.1/8.7/8.5/8.0.1/7. x).

Databases: Oracle 10g/11g (Basic), MS SQL Server 2005/2008 (Basic).

Database Modeling: Star-Schema Modeling, Snowflakes Modeling,Integrated Schema, E-R Modeling,FACT and Dimension Tables,Microsoft VISIO, ERWIN 4/7.1/8.

Networking: Networking:LAN & VPN/Remote Connectivity, TCP/IP

Languages: SQL,PL/SQL, UNIX Shell scripting.

PROFESSIONAL EXPERIENCE

Confidential - Fargo, ND

Data Stage Developer

Responsibilities:

• Involved in Analysis, Requirements gathering, function/technical specification, development, deploying, testing and production support.
• Involved in Design and Data Modeling using Star schema.
• Coordinated with offshore and onshore team.
• Utilized Data stage Parallel Extender PX, to optimize performance in this very large database environment.
• Used Information Analyzer for column analysis, primary key analysis and foreign key analysis.
• Involved in critical multiple instance datastage jobs which will send the outbound files for different Lobs (line of business) at the same time and monitored the jobs accordingly.
• Scheduled the parallel jobs using DataStage Director, which is controlled by DataStage engine and also for monitoring and performance statistics of each stage.
• Created Error Tables containing data with discrepancies to analyze and re-process the data.
• Extensively used Parallel Stages like Join, Merge, Lookup, Filter, Aggregator, Modify, Copy, Sort, Funnel, Change Data Capture, Remove Duplicates, Surrogate key Generator, Row Generator, Column Generator, and Peek for development and de-bugging purposes
• Used DataStage Manager to Import and Export DataStage components and Import table definitions from source databases.
• Execute Backend Testing application by writing complex SQL Queries.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages and triggers for the ETL processes.
• Involved in performance tuning of SQL queries by providing hints, obtaining Explain Plan, Analyzing tables and adding indexes.

Environment: IBM Web Sphere Information Server 8.0.1/8.1 (Designer, Director, Information Analyzer, Quality Stage), Oracle 10g, MS Access 2007, XML, SQL, PL/SQL, Sun Solaris 5.8, TOAD 9.1, Unix Shell scripting.

Confidential - Fargo, ND

Data Stage Developer

Responsibilities:

• Coordinated with client managers, business architects and data architects for various sign offs on data models, ETL design docs, testing docs, migrations and end user review specs.
• Design of Logical and Physical Data Models and developed the STAR Schema models using Erwin tool. Multi source Extraction Transformation and loading into the Repository using Data Stage.
• Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL.
• Developed jobs in Ascential Parallel Extender PX using different stages like Transformer, Aggregator, Lookup, Join, Merge, Modify, Remove Duplicate, Oracle Stage, Sort, Peek, Row Generator, Column Generator, Sequential File, and Data Set.
• Extensively used Sequential File stage, Hashed File Stage, FTP Plug-in Stage and Aggregator Stage during ETL development.
• Extracted data from various sources like Oracle, XML and Flat Files and loaded to target tables. Extensively used DataStage Director for monitoring and debugging of the jobs and Sequences. Used DataStage
• Manager to Import and Export DataStage components and Import table definitions from source databases.
• Extensively worked on the newly developed CDM that will meet or exceed current capabilities, improve flexibility and improve scalability.
• Worked on the Daily atomic, Monthly atomic and Monthly aggregations of the CDM.
• Developed various Data extractions, Transformations rules based on Business requirements.
• Designed ETL jobs to identify and remove duplicate rows using remove duplicate stage.
• Designed DataStage sequences to specify Job execution order.
• Code reviewed of several mappings which could have a performance impact
• Developed of Unix Shell Scripts for automated the loading

Environment: Ascential DataStage 7.5/8.0.1, Oracle 9i, XML, SQL, Erwin, PL/SQL, SQL* Loader, UNIX Shell scripts, Windows XP.