Now you can Instantly Chat with Hemanshu!
About Me
- 11+ years of total IT experience building Datawarehouse & Datalake environment on premises & cloud (Azure & AWS ) platform.
- Expertise in managing platform both inpremise and Cloud platform of hybrid model.
- Expertise acro...
- Expertise across all domain of AWS cloud i.e Compute (EC2, beanstalk, Lambda) , Storage ( S3 , Glacier , EFS) , Security ( IAM , kms)
- Experience in Onboarding 90+ Application ( Architecting & Designing)
- 5+ yrs relevant into Teradata / ETL design & development.
- 3+ yrs relevant experience working on Cloudera Hadoop development.
- 2+ yrs relevant experience working on Azure/AWS Cloud platform.
- 3+ yrs relevant experience working on Kafka & Solr platform
- Good knowledge on Hadoop Cluster architecture and Expertise knowledge on Hadoop framework and its components like HDFS, Spark, Impala, Map Reduce, Pig, Hive, Sqoop, HBase and Oozie.
- Actively involved and guided application team on Performance tuning of Hive & spark Jobs
- Defined best practices for hadoop data management and hadoop hdfs rebalancing.
- Expertise in Hadoop compression mechanism using Snappy / BZIP2 / ORC across various data file format i.e sequence/binary/text etc.
- Sound knowledge on repository data usage on various Reporting tools like BO & Tableau
- Working Knowledge in Performance tuning and troubleshooting.
Skills
Portfolio Projects
Description
EBI Operation is the Production support team of Freescale, Managing entire EBI Cycle of Freescale , which includes development of Change request received time and again from the client in datastage and Teradata SQL.
ØActively involved in managing the entire EBI operation cycle of Freescale.
ØDaily activities include working on change request received from the client (i.e changing the Bteq script to load data as per new business logic and creation of new table loading script and further documentation of the details)
ØInvolved in writing scripts for loading data to target data warehouse using teradata utilities like BTEQ, Fast Load and MultiLoad.
ØAutomation of Process for business by standardization and scheduling.
ØAbend fixing, discrepancy resolution.
ØDefining strategies for migration of Database Objects, Data and Data Quality.
ØMonitored 1600+ jobs running in production environment and provided quick and fast resolution to any load failures.
ØExperienced in archiving, restoring and recovering data on Teradata using ARC utility and TARA GUI.
ØVery well trained and experienced in scheduling backups and recovery of the entire EDW databases across various geographical locations for the business continuity and response time.
ØHandling efficient way of data and DDL backups and environment refreshes.
ØExpert in UNIX scripts for Database extraction and filtering.
ØWrote SQL scripts for backend databases, custom stored procedures, macros and Packages along with Referential Integrity triggers.
ØEnhanced and Customized load scripts to the newly developed and in design projects.
ØExpert in UNIX and shell scripts for Database extraction and filtering.
ØControlled and tracked access to Teradata Database
ØGood experience in creating dynamic Bteq queries using shell script.
ØCreation of one-shots to fix discrepancies In data or processing.
ØInvolved in unit testing Involved and Preparing test cases.
ØInvolved in gathering the requirements for the forms.
ØWritten scripts using Bteq, Fastload, Multiload, Fastexport, Tpump and Queryman.
ØInvolved on error handling with the help of tables like ET, UV and WT.
ØWorked with joins, sub queries, set operations extensively.
ØDid performance tuning at various levels.
ØPrepared BTEQ import, export scripts for tables.
ØWritten BTEQ, FAST LOAD, MULTI LOAD scripts .
ØPrepared FAST EXPORT script for tables.
Show More Show LessDescription
Product Cost Planning was an area within SAP, to plan costs for manufactured materials, services, other intangible goods and set prices for materials and other cost accounting objects. The purpose was to calculate the cost of goods manufactured (COGM) and determine the Cost of Goods Sold (COGS) for each product unit. Cost breakdown by each product and to calculate value added at each stage of completion. Assist in strategic decisions like make vs. buy, pricing, market analysis, Inventory valuation, variances and reserve calculations. The objective of this project was to migrate the lively running database (For Freescale Semiconductor Inc.) from SAP to TeraData
Show More Show LessDescription
ØWorked in all phases in Software Development Life Cycle from requirement gathering to production Implementation of an Entity.
ØUnderstand complex business requirements and transformation for ETL and Reporting with continuous interaction with Clients and BA's.
ØAnalyze and Design the new requirements and find the optimum solution to develop the requirement in DB, Data Modeling, ETL and Reporting.
ØWritten scripts using Bteq, Fastload, Multiload, Fastexport, Tpump and Queryman.
ØInvolved on error handling with the help of tables like ET, UV and WT.
ØCreation of Datastage jobs.
ØWorked with joins, sub queries, set operations extensively.
ØDid performance tuning at various levels.
ØAs part of the SEI CMM Level 5 process, create various documents viz. Estimation sheets, Requirement Analysis, Design Documentation, Mapping Document, Test Cases, RTT log, MOM, Review log, Timesheet and Checklists for ETL, Scripting and Reporting.
Continuous effective coordination and communication with my Team Members, Team Leads, Project Manager, Onsite coordinator, Client, BA's.
Understand and develop complex ETL (Graphs and Shell Scripting), SQL Queries and Reports for various Projects and Modules.
Show More Show LessDescription
ØDevelop effective sourcing and recruiting strategies from `initial screening' to the `offer closure'
ØResponsible for providing desired recruitment solutions to internal and external project within the stipulated time.
ØClosing candidates proactively for Niche skills and generate higher revenues for the company.
ØExtensively experience in working with C2C, W2, 1099.
ØRecruited and placed consultants for Global leaders like, Johnson & Johnson, Wachovia,BCBS, IBM,JPMC, Freddie Mac, Fannie Mae,AT&T, Verizon Telecom, Verizon Business, AIG and more
ØSuccessfully recruited consultants for various software projects on different verticals like Financial, Banking, Brokerage, Insurance, & Consulting firms on Contract.
ØInteraction with Technical Panel/Technical leads/Resource Managers for requirement understanding, technical screening, involve in the overall end-to-end process of recruitment
ØRecruiting via Internet job boards (Dice.com, Monster.com) direct phone sourcing, vendor network, referrals and expanded Internet sourcing.
ØSubmit qualified candidates to the US team.
ØResponsible for screening candidates to ensure their qualifications meet open positions.
ØConducting phone interview for prospective candidates, Coordinating interviews.
Internet savvy to perform targeted Internet research/searches identifying candidates to meet our client needs.
Show More Show Less
Description
CATS ( Collabera Applicant tracking System) is the project of Collabera Consulting Pvt ltd
ØWorked as SQL developer.
ØInteracted with application developers in creating SQL queries for the Functional module.
ØConverted MS Excel worksheets into MS SQL Server 2000 database, such as: Created database and tables/views, Setup relationship among tables, wrote stored procedures, and triggers.
ØOptimized SQL server performance using tools like MS Query analyzer, MS SQL profiler, and index tuning wizard.
Used Crystal Report 11 to generate various reports for business analysis purpose.
Show More Show Less