SUMMARY

• Overall, I have 8 years of experience in various capacities in Information Technology - Most current ETL Developer 2 yrs., Distributed Cluster System - 1 yr. , Microsoft SQL Server technology Overall 3 yrs. and BI Data Analytics of 4-yrs.
• My diverse skills have given me a very unique perspective, where I am able to see topics from many different angles.
• I am truly committed and dependable with good work ethics.
• Possess excellent problem solving, organizational, and communication skills.
• Expert in understanding clients’ needs and requirements.
• Proficient in design and development processes utilizing best standards. Have excellent presentation capabilities, and confidence when presenting technology to non-technical customers or to a group of experts.
• Good understanding of database concepts of data modeling datastage and mapping including normalization, denormalization, dimensionality, referential integrity, indexes, keys, common dimensions, star and snowflake schemas, master data and metadata
• Good understanding of Unix shell scripting, Java and big data components such as spark with Java/scala, Hive, Pig, Hbase, HDFS, MapReduce, Yarn and etc
• Sourcing data from AWS S3 buckets and further loading it into Redshift, SQL Server, MySQL ..etc
• Ability to integrate various data sources including Transactional databases, MS Excel, Web Services, Hive, No-SQL databases, and unstructured data sources
• Scaling and performance tuning of Talend Jobs
• Experience in Error Handling and Debugging Talend jobs
• Expertise in Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema
• Hands on experience with integrating Talend platform with external storage, compute and database systems such as AWS S3 and Redshift.
• Experienced in CDC and daily load strategies of DataWarehouse, Data marts, slowly changing Dimensions (Type1, Type2, and Type3) and Surrogate Keys and Data warehouse concepts.
• Strong experience in SQL Server- T-SQL in constructing Triggers, Tables, implementing Stored Procedures, Functions, Table Variables, Variables and Views
• Created Derived Tables, Nested Derived Tables, Subqueries, and Correlated Subqueries
• Created new tables, Clustered and non-Clustered Indexes required for the new features and altering the tables for change request features and views.
• 1.5+ years of experience using Talend Data Integration
• Exposure to Scala and Python
• Expertise in reading and writing data from multiple source systems like Microsoft SQL Server, MYSQL, Oracle, Flat Files and others
• Access, DB2 db and source files like delimited files, Excel, Positional and CSV files.
• Experience using Talend Integration Suite and using components such as tXmlInput, tXmlOutput, tXmlAdvanced Output, tFilterRow, tMap, tJoin, tReplicate, parallelize, tJava, tJavaRow, tAggregateRow, tDie, tWarn, tLogCatcher, tStatsCatcher, tDie, tLogRow, and many more
• Experience in Performance Tuning and Query Optimization
• Experience with large data sets - regularly transforming and querying tables or sets
• Exposure to AWS EC2, S3, Hive, Pig
• Exposure (theory) in database design, development and data modeling - SSAS
• Exposure (theory) to SSIS packages
• Ability to identify problems, and effectively communicate solutions to the team
• Worked in a dynamic multi-team environment as well as independently
• Worked with SSRS, Crystal, Tableau and Hive Reporting tool

TECHNICAL SKILLS

Reporting Tools: Hive, Pig, Crystal Reports, Design Studio (Business Objects 41/42),, Web Intelligence

ETL Tool: Sqoop, BODS 41, SSIS, Talend

Database: MS SQL Server 2008 R2, 2012, MySqk HBase

Languages: Python, Java, Scala

PROFESSIONAL EXPERIENCE

Confidential, Waukegan, IL

Talend Developer

Responsibilities:

• Project mostly consisted of conversion of Crystal Reports to SSRS and fixing issues in process.
• Integrated java code inside Talend studio by using components like tJavaRow, tJava, tJavaFlex and Routines.
• Used ETL methodologies and best practices to create Talend ETL jobs. Followed and enhanced programming and naming standards.
• Created and deployed physical objects including custom tables, custom views, stored procedures, and Indexes to SQL Server for Staging and Data-Mart environment.
• Worked on various Talend components such as tMap, tFilterRow, tAggregateRow, tFileExist, tFileCopy, tFileList, tDie etc.

Confidential, Deerfield, IL

Talend Developer

Responsibilities:

• Running ETL process on Hadoop HDFS using Hive, Pig and Talend
• Extract transformed and load process with SQL Server Database tables and AWS S3 busket using load function for flat files, JSON, XML and all other flat files.
• Written UNIX shell scripting, SQOOP.
• Worked with NoSql Databases HBASE
• Developed Pig scripts/Hive QL, UDF for analyzing all semi-structured/unstructured/structured data flows.
• Worked on cloud computing infrastructure (e.g. Amazon Web Services EC2)
• Demonstrate Integration best practices with focus on Talend.
• Good knowledge working with version control tools like GIT and SVN.
• Implemented business rules in Talend by creating Reusable Transformations and robust mappings/mapplets.
• Data loading, troubleshooting, Debugging and tuning of Talend mappings.
• Creation of objects such as tables, views, indexes, stored procedures, functions, derived tables, CTE, Variables and triggers & maintaining Referential Integrity using T-SQL to provide definition, structure and to maintain data efficiently
• Effectively used Triggers to prevent unauthorized access, hide complexity and to optimize queries
• Restricted data for particular users using row level security constraints
• Created Variables, Ranking, Synonyms, Offset-Fetch, Intersect and Except
• Created Derived table, Subqueries, Simple queries, joins and common table expressions
• Temporary tables, Correlated, Scalar and Multivalued subqueries
• Case statements, Stored Procedures, input, output and multiple input parameters
• Created T-SQL scripts to perform complex queries and complex data manipulations
• Eror handling using TRY CATCH block in Microsoft SQL Server
• Developed a Tabular Reports, ad-hoc reports using SSRS Report
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Expertise in reading and writing data from multiple source systems like oracle, Microsoft SQL, MYSQL,
• Access, MySQL, SQL Server and source files like delimited files, Excel, Positional and CSV files.
• Experience using Talend Integration Suite and using components like tXmlInput, tXmlOutput, tXmlAdvanced Output, tFilterRow, tMap, tJoin, tReplicate, parallelize, tJava, tJavaFlex, tAggregateRow, tDie, tWarn, tLogCatcher, tStatsCatcher, tDie, tLogRow, Talend Data Integration
• Created Talend custom components for the various use cases and worked on XML components, Data quality, Processing and Log & Error components.
• Strong Knowledge on Data Warehousing Basics and relational database management Systems and
• Dimensional modeling (Star schema and Snowflake schema).
• Implemented Error Logging, Error Recovery, and Performance Enhancement's & created Audit
• Well versed with Talend Big Data, Hadoop, Hive and used Talend Big data components like tHDFSInput, tHDFSOutput, tPigLoad, tPigFilterRow, tPigFilterColumn, tPigStoreResult, tHiveLoad, tHiveInput, tHbaseInput, tHbaseOutput, tSqoopImport and tSqoopExport.

Confidential, Milwaukee, Wisconsin

SQL Server Developer

Responsibilities:

• Maintenance, support and modifications of existing SSRS reports.
• Created Stored Procedures, Triggers, Views and other Database Objects.
• Worked closely with the business and analytics team in gathering the system requirements
• Converted Crystal Reports to SSRS, fixed issues in process
• Created SSIS Packages to Extract, Transform and Load (ETL) the data into reporting instance to generate the reports.
• Loaded data from various sources (MS Excel, MS Access, Flat Files to SQL Server using SSIS)
• Writing complex queries using derived tables, nested derived tables, subqueries as per requirement need.
• Written User Defined Functions, created Table Variables, Variables, assigning Identity Properties and working with Constraints to ensure integrity and quality data.

Confidential, Indianapolis, IN

SAP BIBO Developer

Responsibilities:

• Used SAP Business Objects to build universe and reports
• Developed universe for the Sales and Marketing Department to Analyze Sales and enable Marketing Team to make informed decisions
• Consulted with business clients, creating Tableau dashboard reports, collaborating with developer teams, using data visualization tools, there were numerous 'As-Is' and 'To-Be' conditions
• Involved in creating database objects such as tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Restricted data for particular users using Row level security and User filters
• Developed Tableau visualizations and dashboards using Tableau Desktop

Confidential, Cincinnati, OH

SAP BIBO Developer

Responsibilities:

• Gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes Webi, Tableau, and Crystal Reports
• Involved in designing Universe and migrating existing Desktop Intelligence (Deski) Reports to Web Intelligence (Webi) report
• Set up the security levels to the users in universe module like row level and object level security
• Designed and developed the Functional Analysis and Technical Design like Joins, Shortcut Joins, Contexts, and Cardinalities of the tables and structures of the Universe
• Architected and developed financial dashboards (Variance Price Exchange, Daily Sales, Profit and Loss) using best dashboard design practices
• Created shell script to automate Business Objects Reports since Business Objects Enterprise warehouse is running on UNI