OBJECTIVE:

To secure challenging position in Business Intelligence, Analytics /BigData

PROFILE:

• Technically sophisticated & result driven IT Professional, with an experience of 13+ years including Two Major Wire line Telecom companies Windstream and Confidential and Health care giant Confidential .
• Proven Technical and Project Management skills, with a proven track record of managing small to medium projects.
• Certified PRINCE2 Practitioner (Project Management), ITIL & ITSM and follower of PMBOK standards.
• Extensive knowledge on visualization of data and knowledge of tools such as Tableau and QlikView.
• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts etc... Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
• Worked on different table calculations for different Scorecards.
• Experience in BigData in HADOOP ecosystems and related technologies (HDFS, MapReduce, Hive, Pig, Impala, Splunk).
• Exposure on Big Data industry top distributions giants like Cloudera(CDH), HortonWorks (HDP) and Apache Hadoop platforms
• Good Experience in data loading from RDBS system to HDFS system using SQOOP and Flume.
• Worked on data blending and increased the dashboard performance by extracting data.
• Worked on Data modeling & Data Mappings, Data validation, Match and Merge rules, writing and customizing user exits, customizing/configuring Data Director Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Worked in Pre - Sales activities and Technical Discussions / Architecture for Internet Solutions (SA), Arqiva Smart Water Works (Europe), Bright House Networks (USA), Confidential (USA) etc clients.
• Experience with designing complex dashboards and functions including data blending, actions, parameters
• Experienced in COTS Products (MyCom(OSI) NetExpert, Oracle Metasolv, Sasktel Martens, Sasktel Open Switch Gate(OSG)), BI tools, Informatica, Datastage, Bigdata, C, C++, Java, UNIX, Shell Scripting, Oracle, PL/SQL, TOAD, PRO*C, Selenium, Informix, Informix 4GL, Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in Informatica Power Center, Informatica Data Quality, Power Exchange and Metadata Manager.
• Expertise in Client-Server application development using Informix/Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Created and maintained databases to track business performance.
• Analyzed data and summarizes performance using summary statistical procedures.
• Developed and analyzed business performance reports and provides notations of performance deviations and anomalies.
• Created and published periodic reports, as well as any necessary ad hoc reports.
• Good knowledge in developing complex mappings, mapplets and reusable transformations.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Hands on Integration and conversion projects and also excellent in handling 24x7 Support, Solid People management skills, demonstrated proficiency in leading and mentoring individuals to maximize level of productivity, while forming cohesive team environment.
• Acknowledged Technical Lead, mentor and a trainer with ability to create and sustain high work tempo. Exceptional analytical and troubleshooting skills, ability to prioritize; take decisions and work in tandem with different stakeholders across geographies ensuring on time solutions.
• Knowledge of e-Tom frameworks

IT SKILLS:

BI Reporting Tools: Tableau, QlikView, QlikSense

Big Data Technologies: Hadoop, MapReduce, Pig, Hive, Sqoop, Oozie, Flume, Splunk, HBase

COTS: Mycom(OSI) NetExpert, Metasolv, Sasktel Martens & Open Switch Gate(OSG)

Programming Languages: PL-SQL, Java, C, C++, CORBA, COBOL, Informix 4GL, Visual Basic 6.0

Databases: Oracle (9i, 10g,11g), Informix, DB2,MS SQL Server

Script: XML,HTML, JSON,VB Script, Java Script, shell script

Tools: & Utilities: ServiceNow, BMC Remedy, SVN, VSS, Clear Case, TOAD,PL/SQL Developer

Domain Knowledge: Telecom, Manufacture, Education & Healthcare

Systems: Windows, SUN Solaris, HP Unix

Methodologies: SDLC, Agile, UML, Scrum

Scheduling Tools: MS Project

ETL Tools: Informatica Power center, Informatica Power Exchange, IBM DataStage 7.5

Data Modeling Tools: MS Visio and Erwin

PROFESSIONAL EXPERIENCE:

Confidential

Sr Consultant

Responsibilities:

• Data Model design creation of tables, sequences and views
• Extraction data from Hive, Hue on Cassandra Environment
• Used pig for business transformations
• Design of Qlik Marts for Actual onhand inventory, Annual Financial Plan and Update and Annual Financial Plan-adjustments and Update-adjustments
• Calculation of Net BOH, Plan BOH, and Net Variance values using TCGM factors.
• Role based security shall be introduced to implement access control over user inputs and reporting using section access.
• History inventory data (Actual onhand inventory, max two year old) from ECC shall be captured from Next Generation Analytics platform.
• Created and designed QlikView Publisher jobs
• Design, build, test and debug QlikView solutions based upon specified requirements
• Developed optimized load strategies; including Binary, Partial and Incremental Load

Confidential

Sr Consultant

Responsibilities:

• Gathered and analyzed business requirements
• Data Model design creation of tables, sequences and views
• Created Cybermation flow, scripts to extract data from Flat file and store in staging tables.
• Created a stored procedures, functions to process data by applying the business rules from staging tables
• Developed SCD’s (Slow Change Dimensions), MERGES, Identification of GOLDEN record
• Integration with MDM systems to master records
• Created optimal tables and stored procedures for report design
• Analyzed and designed business reports and dashboards in QlikView
• Gathered, analyzed and designed reports/dashboards referencing current trade markets and profit centers using QlikView software applications
• Utilized and designed OLAP cubes for report, dashboard and scorecard design
• Designed intuitive visuals utilizing; containers, sliders, charts, pivot tables, etc.
• Developed and designed business applications utilizing QlikView
• Modeled data requirements to successfully create graphs and metrics in QlikView as needed for end-users
• QlikView software system development and maintenance using industry standard tools and methods
• Worked with multiple QlikView components such as QVW, QVD and distribution services
• Migrating code across development, testing and production environments
• Attending the development and testing calls, fixing the bugs if any reported

Confidential

BI Lead

Responsibilities:

• Gathered and analyzed business requirements
• Worked on data extraction from different sources using queries/procedures and scripting.
• Extraction data from Hive, Hue on Cassandra Environment
• Used pig for business transformations
• Created optimal tables and stored procedures for report design
• Analyzed and designed business reports and dashboards in QlikView
• Gathered, analyzed and designed reports/dashboards referencing current trade markets and profit centers using QlikView software applications
• Utilized and designed OLAP cubes for report, dashboard and scorecard design
• Designed intuitive visuals utilizing; containers, sliders, charts, pivot tables, etc.
• Developed and documented new solutions to frequently asked questions
• Developed and designed business applications utilizing QlikView
• Designed dashboards and reports using QlikView scripting, ETL process and front-end development
• Modeled data requirements to successfully create graphs and metrics in QlikView as needed for end-users
• QlikView software system development and maintenance using industry standard tools and methods
• Worked with multiple QlikView components such as QVW, QVD and distribution services
• Migrating code across development, testing and production environments
• Created and designed QlikView Publisher jobs
• Design, build, test and debug QlikView solutions based upon specified requirements
• Developed optimized load strategies; including Binary, Partial and Incremental Load
• QlikView Integrated with R to predict the expected churn.

Confidential

BI Lead

Responsibilities:

• Gathering analytical requirements from Business Users and translate into technical requirements.
• Requirement gathering, Design and Development of Dashboards, user driven reports, comparison reports
• Delivers high quality Reporting & Analytics solutions that meet user requirements with minimal on-going maintenance and a low volume of production incidents (production failures, help desk calls, etc.).
• Experienced in SQL in an Oracle and DB2 Server environment. Proficient with complex SQL (multi joins, sub-queries, unions) and creation of database objects (tables, views, materialized views, etc.). Ability to utilize performance tuning utilities (Explain Plans, etc.) to optimize queries.
• Extract, Transform and Loading data from application, network management systems
• Ability to provide high level architecture/design for Service Fulfillment applications
• Demonstrated skills to provide the user with tools to diagnose the different operational and provisioning changes in the network
• Extraction data from Hive, Hue on Cassandra Environment
• Used pig for business transformations
• QlikView Integration with R and Salesforce
• Experienced in deployment methodologies/processes utilizing QlikView Server
• Good knowledge of QlikView server architecture, administrative functions, installation and building QVD's and QVW's
• Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access).
• Developed QlikView Dashboards using Chart Box (Bar, Line, Combo, Pivot, and Straight, Drill Down, Drill up & Cyclic Grouping etc.), List, Input Field, Table Box, Groups, Chart Box
• Experienced as a lead mentoring other developers.
• Attending scrum calls on daily basis, report status updates and issues if any
• Assist with developing estimates and describing solutions during the proposal process
• Liaison in setting up testing environment with other groups
• Off-shore and On-Shore Co-ordination.

Confidential

Technical Lead/Technical Manager

Responsibilities:

• Requirement gathering, Design of Fault Network Management Systems using the NetExpert OSI development suite
• Handled Projects, Portfolio report Management and also owned complete delivery responsibility for few small to medium projects.
• Handling the client calls, risks in projects
• Architecture and Integration diagrams development using MS Visio
• Design of Dashboards, user driven reports, comparison reports for Fault Management
• Design and guiding the team to develop the procedures and triggers in various phases to integrate with other systems.
• Wrote Perl/shell scripts to automate the manual process.
• Closely monitoring the SLA and application support
• Ability to provide high level architecture/design of NetExpert
• Demonstrated skills to provide the user with tools to diagnose the different operational and provisioning changes in the network
• Liaison in setting up testing environment with other groups
• Integration of UNE/POTS, ADTRAN, Remedy ITSM with NetExpert

Environment: Mycom (OSI) NetExpert, Oracle 11g, Unix, Perl, Shell Scripting, Java, Spring

Confidential

Lead Developer/ Technical Lead

Responsibilities:

• Design & development of enhancement and conversion projects.
• Performed business analysis and requirements gathering from high-end users and managers.
• Dashboards, KPI and Daily, Weekly, Monthly, custom report using Tableau to control dispatch issues (2012 onwards)
• Architecture and Integration diagrams development using MS Visio
• Complete Technical delivery responsibility of WFM for few small projects.
• Managing a technical team, monitoring, work allocation and issue resolution.
• Coordinating with the customer on daily basis.
• Meeting SLA requirements and Application Support on 24x7 basis.
• Guide team to Development of 4GL Program for as per Help Desk requirements and preparing the various documents as per Windstream requirements.
• Hands of experience on Migration/Conversion projects.
• Performance Monitoring and issue resolution.
• Remedy tool - Ticket management, Change request Management and Problem Management
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Parsing high-level design specifications to simple ETL coding and mapping standards. Designed mapping document, which is a guideline to ETL Coding.
• Analyzed and created Facts, Dimension tables. Modeled the data warehousing data marts in Star join schema.
• Developed a frame work to migrate the data from different sources RDBMS using ETL tools, Packages, Procedures and scripts.
• Coordination between business/IT teams on both sides.
• Involving infrastructure teams as and when required to overcome the technical needs.
• To involve in business discussions to identify functional gaps between the source and destination applications.
• Monitor traffic and estimate capabilities during System and UAT testing.
• Perform analysis of current WFM load versus anticipated load after conversion.
• Escalate as an overall project risk. This is not limited to WFM, CTS and TAP.
• Address the throughput issues and perform cross application stress testing.
• Provided functional and technical designs for the conversion programs and the data scrubs.

Environment: Informatica V8.x 9.x, Oracle 11g/10g, Informix, SQL Server, PL/SQL, CDC, XML, Flat Files.

Confidential

ETL & Report Developer

Responsibilities:

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Parsing high-level design specifications to simple ETL coding and mapping standards. Designed mapping document, which is a guideline to ETL Coding.
• Analyzed and created Facts, Dimension tables. Modeled the data warehousing data marts in Star join schema.
• Dashboards, KPI and Daily, Weekly, Monthly, custom report using Tableau

Environment: Tableau 8.0, Informatica V8.x 9.x, UNIX, Toad 9.0.1.8, Oracle 11g/10g, Informix, CDC, XML, Flat Files, AutoSys, Shell Scripting, Windows 2000 XP.