About Me
Experienced developer with background of 8+ years in business intelligence and data analysis across various industries. Excel at creating tools/solutions and leading efforts to improve data analysis and organizational ca…
Experienced developer with background of 8+ years in business intelligence and data analysis across various industries. Excel at creating tools/solutions and leading efforts to improve data analysis and organizational capacity, increase efficiency, simplify processes, and enhance performance and features. Skilled at tracking, analyzing, and rectifying data collection and processing issues.
Experience
IT Analyst
Role-Datastage developer
Responsibility-
Designing jobs based on the requirements.
Preparing high level documentation.
Monitoring jobs untill moves to production.
Supporting production tickets.
Designing jobs using transformations and different stages
Mapping based on business rule
Applying logics on to satisfy the conditions.
TECHNOLOGY ANALYST
Hands-on experience in data analytics tools like Excel, DAX, SQL Server, etc.
Involved in creating new stored procedures and optimizing existing queries and stored procedures.
Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
Explore data in a variety of ways and across multiple visualizations using Power BI.
Have sound knowledge of database management systems, data modeling, data warehousing, data visualization, business intelligence, OLAP (Online Analytical Processing), etc.
Knowledge of various software development life cycle models and documentation.
Used Power BI Gateways to keep the dashboards and reports up to date.
TECHNOLOGY ANALYST
Hands-on experience in data analytics tools like Excel, DAX, SQL Server, etc.
Involved in creating new stored procedures and optimizing existing queries and stored procedures.
Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
Explore data in a Variety of ways and across multiple visualizations using Power B
Have sound knowledge of database management systems, data modeling, data warehousing, data visualization, business intelligence, OLAP(Online Analytical Processing), etc
Knowledge of various software development life cycle models and documentation.
Used Power BI Gateways to keep the dashboards and reports up to date.
DATA STAGE DEVELOPER
Extensively used DataStage Client components: DataStage Designer, DataStage Manager and DataStage Director.
Got the source data in the form of Oracle tables, Sequential files and Excel sheets.
Developed processes to extract the source data and load it into the data warehouse after cleansing, transforms and integrating.
Imported metadata from repository, created new job categories, routines and data elements.
Transformations were used in DataStage to load data to Oracle and updated using PL/SQL.
Created Job Sequencer to execute a set of jobs.
Power BI DEVELOPER
Used the DataStage Designer to debug processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database and also the process of loading data into Data-mart.
As a data analyst responsible for solving high priority incidents and identifying the errors and resolving the errors and making job to run again.
Used the IBM WebSphere DataStage designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
Got the source data in the form of Oracle tables, Sequential files, mainframe files.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Used the Tidal job Scheduler to schedule the DataStage jobs to run the daily jobs and weekly jobs.
Validated the current production data, existing data and the programming logic involved.
DATA STAGE DEVELOPER
Extensively used DataStage Client components: DataStage Designer, DataStage Manager and DataStage Director.
Got the source data in the form of Oracle tables, Sequential files and Excel sheets.
Developed processes to extract the source data and load it into the data warehouse after cleansing, transforms and integrating.
Imported metadata from repository, created new job categories, routines and data elements
Transformations were used in DataStage to load data to Oracle and updated using PL/SQL.
Created Job Sequencer to execute a set of jobs.
Power BI DEVELOPER
Used the DataStage Designer to debug processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database and also the process of loading data into Data-mart.
As a data analyst responsible for solving high priority incidents and identifying the errors and resolving the errors and making job to run again.
Used the IBM WebSphere DataStage designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
Got the source data in the form of Oracle tables, Sequential files, mainframe files.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Used the Tidal job Scheduler to schedule the DataStage jobs to run the daily jobs and weekly jobs.
Validated the current production data, existing data and the programming logic involved.