SUMMARY:

• Technically sophisticated & result driven IT Professional, with an experience of 15+ years
• 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.
• Experienced in SDLC, Agile (Scrum) methodologies and handled multiple applications, enhancement and conversion projects at same time.
• Hands on Integration and conversion projects and also excellent in handling applications and projects 24x7 Support, Solid People management skills, demonstrated proficiency in leading and mentoring individuals to maximize level of productivity, while forming cohesive team environment.
• Exceptional analytical and troubleshooting skills, ability to prioritize; take decisions and work in tandem with different stakeholders across geographies ensuring on time solutions.
• Worked in Pre - Sales activities and Technical Discussions / Architecture ( TOGAF/Zachman)
• Extensive knowledge on visualization of data and knowledge of tools such as Tableau and QlikView.
• Experience in BigData in HADOOP ecosystems and related technologies (HDFS, MapReduce, Hive, Pig, Impala, Splunk).
• Good Understanding on Cloud - AWS/EC2/S3/RDS/VPC/Snowball/Lambda/Storage Gateways
• Exposure on Big Data industry top distributions giants like Cloudera(CDH), HortonWorks (HDP) and exploring on Optum platform.
• 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.
• Experience in Informatica Power Center, Informatica Data Quality, Power Exchange and Metadata Manager.
• Experience with designing complex dashboards and functions including data blending, actions, parameters
• Good Experience in data loading from RDBS system to HDFS system using SQOOP and Flume.
• Expertise in Client-Server application development using Teradata/Informix/Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• 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.
• 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.
• Good knowledge of different BI Tools, client/server architectures and various compatibility requirements.
• Effectively lead teams and inspire others to achieve goals through innovation, quality and excellence.
• Experience in troubleshooting, software development processes and ability to understand and implement client requirements.

TECHNICAL SKILLS:

BI Reporting Tools: Tableau, QlikView, QlikSense

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

Cloud: AWS/EMR/EC2/S3/VPC/RDS/Snowball

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, Jira

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

Data Modeling Tools: MS Visio and Erwin

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

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Sr. Data Architect & Technical Project Manager

Responsibilities:-

• Responsible for Scrum Planning, Scrum meetings and detail architectural design.
• Data Modelling, Dimension Modelling, Database Designing using ER Studio.
• Data Profiling and identify data quality rules. Data map and gap analysis.
• Responsible on Data wrangling, data profiling and Source to target mapping.
• Involved in old MIS to new MIS conversion (Sybase to Oracle)
• Weekly status updates to enterprise teams on Project status, Architectural discussions

Environment: Sybase, Oracle, TOAD, SQL Developer, MS Visio, ER Studio, Power designer, Informatica, OBIEE

Confidential, Plymouth meeting, PA

Sr Consultant (Lead/Architect level)

Roles & Responsibilities:

• Data Model design creation of tables, sequences and views
• Injection of data into Data lake, 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
• Role based security shall be introduced to implement access control over user inputs and reporting using section access.
• Importing and exporting data using Sqoop from Teradata, Oracle to Hadoop and vice-versa.
• Worked on Hive tables, loading data and writing Hive queries and also used Pig for Transformation.
• Wrote BTEQ scripts, Teradata utilities fast load, multi load, tpump.
• Design, build, test and debug QlikView solutions based upon specified requirements
• Helped team to setup load strategies; including Binary, Partial and Incremental Load
• Effective at prioritizing tasks, managing time, and getting things done with team
• Managed daily calls with onshore, offshore and testing team
• Used HP Quality control to track and bugs reported by testing team and managed and helped team to fix those.

Environment: Oracle, Terradata, Hadoop, Sqoop, Hive, Pig, Hue,TOAD, SQL Developer, MS Visio, Qlikview

Specialty Data Integration

Roles & Responsibilities: Sr Consultant

• Gathered and analyzed business requirements
• Delegate and allocate responsibilities efficiently to manage projects end to end
• Provided direction and technical expertise in design, development and systems integration
• Ability to communicate effectively with teams and clients
• 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 procedure, 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 (HP Quality center) if any reported

Environment: Oracle, MS SQL Server, TOAD, SQL Developer, Erwin, PVCS, Qlikview

Confidential, Vancouver, WA

BI Lead/Architect

Roles & Responsibilities:

• Preparation of Estimations and WBS, tasks priority, tracking the activities.
• Onshore and offshore coordination, meetings, minutes of meetings, client co-ordination.
• Architecture design of the data flow and interaction with different stake holders.
• Worked on data extraction from different sources using queries/procedures and scripting.
• Used pig for business transformations
• Created optimal tables and stored procedures for report design
• Worked on Hive tables, loading data and writing Hive queries and also used Pig for Transformation.
• 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
• Importing and exporting data using Sqoop from Oracle to Hadoop and vice-versa.
• 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
• Design, build, test and debug QlikView solutions, publish the job based upon specified requirements
• Helped team to build the optimized load strategies; including Binary, Partial and Incremental Load
• QlikView Integrated with R to predict the expected churn.
• Guided the team through the development, testing and implementation stages and review the completed work effectively

Environment: Oracle, Hadoop, Sqoop, Hive, Pig, Hue,TOAD, SQL Developer, MS Visio, IBM DB2, Unix, Perl, Qlikview,Shell Scripting

Confidential

Roles & 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.).
• Able to make quick decisions and solve technical problems to provide an efficient environment for project implementation
• 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.
• 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
• Importing and exporting data using Sqoop from Oracle to Hadoop and vice-versa.
• Extraction data from Hive, Hue on Cassandra Environment
• Used pig for business transformations
• QlikView Integration with R and Salesforce
• Experienced as a manager/lead mentoring other developers.
• Organized and 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.

Environment: Oracle, Hadoop, Sqoop, Hive, Pig, Hue,TOAD, SQL Developer, MS Visio, IBM DB2, Unix, Perl, Qlikview,Shell Scripting

Confidential

Technical Lead/Technical Manager

Roles & 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.
• Estimation and project plan development for enhanced and new projects
• Performed day to day operational support without additional support and guidance
• Self-directed, effective at prioritizing tasks, managing time, and getting things done with team
• Detail-oriented individual with the ability to rapidly learn and take advantage of new concepts and technologies
• Handled multiple applications and projects and lead and/or facilitate cross-functional projects, and manage conflicts within groups
• Resource management skills and ability to handle complex / sensitive issues
• 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
• Experienced in preparation/review of FDD, TDD, Implementation plans as needed
• Used JIRA process flow for project related approvals
• Communication of project status to vendors, stakeholders, and resources
• Liaison in setting up testing environment with other groups
• Integration of UNE/POTS, ADTRAN, Remedy ITSM with NetExpert
• ROI: Integration of NetExpert with Trouble Ticket System(BMC Remedy) to auto generate tickets. OSI quoted $196,443.00 to integrate NetExpert with BMC Remedy. But, I have provided another feasible solution to Windstream with minimal cost and achieved 95% functionality as the tool provides.
• Conducted performance reviews of team members and identify areas of improvement, give feedback and recommend for promotions or salary increments
• Preparation of MOM, project closure activities, Knowledge base development etc.

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

Confidential

Responsibilities:

• Design & development of enhancement and conversion projects.
• Performed business analysis and requirements gathering from high-end users and managers.
• Effectively prioritize and execute tasks in a high-pressure environment
• Technical architecture and design of the applications interaction and data flow
• Handled Confidential and CTS applications, enhancement and conversion projects at same time
• 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 Confidential 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.
• Used JIRA process flow for project related approvals
• 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
• Identification of resource and equipment requirements, efficient capacity planning and manage software and hardware availability
• Encouraged team interaction, boost employee motivation and appreciate team contribution
• Followed Waterfall methodology for projects

Environnent: Informix 4GL, Informix, HP-UX, Shell Scripting, ESQL/C, Perl, Oracle, VC++, Windows, Handheld Devices, Tableau 7.0